Database for Windows Phone 7

Question

I'm looking to release a really simple application for windows Phone 7. Unfortunately, My Apps need to store some data in the device. say a Database.

My colleague found one SQLite library - http://sviluppomobile.blogspot.com/2010/03/sqlite-for-wp-7-series-proof-of-concept.html

But How about Linq to SQL or EF for Windows Phone 7. Any Library for this?

Answer 1

You could try using SQL Server Compact.

Info about compact and linq

Answer 2

In the initial release of Windows Phone 7 you have no SQL Server Compact or similar. Because no user app can call P/Invoke no other mobile/compact database will work.

To store content you have to use Isolated Storage and build something with this. See this: http://winphone7db.codeplex.com/

Answer 3

Perst works well under Windows 7

Answer 4

Jira,

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