0 Replies - 768 Views - Last Post: 28 April 2011 - 06:49 AM

#1 eclipsed4utoo  Icon User is offline

  • Not Your Ordinary Programmer
  • member icon

Reputation: 1533
  • View blog
  • Posts: 5,972
  • Joined: 21-March 08

[LINK] Using SQLite in a Windows Phone app

Posted 28 April 2011 - 06:49 AM



In the current version of Windows Phone, there’ s no support for a built-in local database. This will be taken care of in the next release of the OS (codename “Mango”), which will be released late this year. Mango will have a built-in SQL CE (-like) database which can be accessed using LINQ to SQL. At the time of writing, there seem to be a few drawbacks you’ll have to keep in mind:

The backend store is in a non-standard format
It’s not possible to execute ad-hoc SQL queries (neither DDL nor DML)
Shipping a database file with your app is a complicated process
If any of these limitations is a blocker for your application, or you just want to have a local database right now, using SQLite is a great alternative.

Is This A Good Question/Topic? 1
  • +

Page 1 of 1