Local Sql database support for Windows phone 7

Question

I would like to develop for Windows Phone 7 but the lack of database support still blocks me. Has anyone found a good library, stack to use for accessing local database from WinPhone7? Can you post links/examples of good practices to select/insert data in DB from a WinPhone7 application?

Thanks in advance ! c.

Answer 1

Take a look at winphone7db. This project implements a Isolated Storage (IsolatedStorage) based database for Windows Phone 7. The database consists of table object, each one supporting any number of columns.

Or you can store data on the internet and use webservices.

Answer 2

There are lots of options:

WinPhone7Db
Perst
SQLite
siaqodb
db4o
Ninja Database Pro
SQL Compact Edition should also be coming in the future.

Answer 3

Cris,

We just came out with Ninja Database Lite for Windows Phone 7, Silverlight, and .NET 3.5 and higher. It is free until October 31st, 2010.

http://www.kellermansoftware.com/t-ninja-forums.aspx

Thanks, Greg