Windows Phone Local Database tip: Initializing the database

source: erikej.blogspot.com

There are several options for initializing the database for Window Phone, depending on your approach. By "initializing" I mean preparing the database for first use, just after the application has ben installed.

Whether you create the DataContext by hand or use RAD "Database First" with the SQL Server Compact Toolbox or the ExportSqlCe command line utility is not relevant.

You can read more about Database First here: http://erikej.blogspot.com/2012/01/generating-linq-to-sql-datacontext-with.html and more about Code First here: http://msdn.microsoft.com/en-us/library/hh202876(v=VS.92).aspx

I will assume you have used one of my tools to create the DataContext classes.

Option 1: No database file included

In this case, there is no initial data in the local database, it will be populated either by getting data from the web, or by manual entry by the user. The database must be writable, and must therefore reside in Isolated Storage. The connection string look like this: "Data Source=isostore:/Chinook.sdf"

...Read more

You can also follow us on Twitter @winphonegeek

Comments