Menu
I have built a Windows Phone Application using SQL Server CE database.
We need transplant this app to Windows 8 Metro Style.
Do Windows 8 Metro-style applications support SQL Server CE local databases?
265
The primary difference between SQL Server and Windows Server is what they're made for: SQL Servers store raw data, while Windows Servers allow you to store documents like images, projects, spreadsheets, or Word documents.
SQL Server 2019 allows you to directly upgrade from SQL Server 2008/R2 and keep the database compatibility to the earlier version.
If you only need a small database for development to store data in tables, the SQL Express will be enough. If you do not have too much disk space, the SQL Express will be the best option. If you need to test advanced functionality of SQL Server, the Developer edition is your best choice.
As already answered by ErikEJ, there is no native support for a local SQL Server CE database, but maybe this third party component SQLite is usefull for you?
Tim Heuer has wrote a blogpost about how to use SQLite in a metro style app: http://timheuer.com/blog/archive/2012/05/20/using-sqlite-in-metro-style-app.aspx
In the blogpost there is also a video with the "How to" steps to use SQLite in your app.
55
No, currently Microsoft does not provide a local database for Metro applications with C# and XAML.
42
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
