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.
[edited] any updates available?
LinqConnect for Windows Phone contains the SQLite embedded database engine from C# SQLite project.
An instance of SQL Server Express LocalDB is an instance created by a user for their use. Any user on the computer can create a database using an instance of LocalDB, store files under their user profile, and run the process under their credentials. By default, access to the instance of LocalDB is limited to its owner.
Use SQL Server Management Studio In Object Explorer, connect to an instance of the SQL Server Database Engine and then expand that instance. Right-click Databases, and then select New Database. In New Database, enter a database name.
There are lots of options:
WinPhone7Db
Perst
SQLite (and here)
siaqodb
db4o
Ninja Database Pro
Rapid Repository
Sterling
Effiproz
SQL Compact Edition will be coming in the "Mango" update - due later this year
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With