I am maintaining a simple set of records. I want to store these records as table on my Windows phone.
I have come across Linq-to-SQL. My question is, is it the default database provided by the Windows phone system just as SQLite is provided by ANDROID?
Is Linq-to-SQL used by the Windows phone native apps like Contacts Manager?
I have also come across SQLite support for Windows phone. I am able to install the necessary extensions and packages required.
My question here is, when I will deploy my application on the phone, is there a need to install the SQLite library separately first for that phone?
When we include the extension in our Visual Studio IDE then while deploying my application on the phone does the IDE take care of installation of SQLite on the phone?
Best How To :
SQLite's distribution contains everything needed to make use of a local database file asset packaged within its DLL that you reference in your project when you pull in its NuGet package. No additional installations or assets are required by users of your applications.
If you are interested in Microsoft technologies for use with your project, you're looking for SQL Compact 3.5. Compact 4.0 is not currently supported by Windows Phone. You can create a new compact database SDF file and add it to your project as an embedded resource, then access it with a connection string as simple as
isostore:/FileName.sdf. You'll still need to generate a DB context and entities to make use of the database, but I've found that I can use LINQ-to-SQL's ORM and import the generated classes, removing the two unsupported interface context constructors that aren't in the Windows Phone library.