Database for Windows Phone 7 [closed]

Question

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance.

Closed 7 years ago.

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

Perst works well under Windows 7

Answer 2

SQLite worked fine for me. Complex joins are slower, but that I bet that would be true for any database. I have over 50MB of data in case you are wondering.

Answer 3

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 4

You could try using SQL Server Compact.

Info about compact and linq