Which local database is suitable for Windows 8 Store Apps?

c# database sqlite visual-studio-2012 windows-store-apps
Simon Schürg picture Simon Schürg · Nov 25, 2012 · Viewed 17.3k times · Source

I'am programming a Windows 8 Store App (Metro Design) with C# and XAML using Visual Studio 2012.

There is no need for a database server with multi user support etc.

I want to store my data in a local database and don't know which database is suitable for my needs. Maybe SQLite? Or are there solutions that fits better for Windows Store Apps and integrates better in Visual Studio?

The app is kind of a calender and the database should store the user data that consists of the dates, tasks and so on.

Answer

Ercan Özdemir picture Ercan Özdemir · Feb 5, 2013

SQLite is supported for WinRT.

http://visualstudiogallery.msdn.microsoft.com/23f6c55a-4909-4b1f-80b1-25792b11639e

Related questions

Is there a .NET/C# wrapper for SQLite?

I'd sort of like to use SQLite from within C#.Net, but I can't seem to find an appropriate library. Is there one? An official one? Are there other ways to use SQLite than with a wrapper?

Read More
How to use(create db, create table, query, etc) praeclarum sqlite-net?

I want to use sqlite-net available from this link https://github.com/praeclarum/sqlite-net. Unfortunately, the getting started documentation are not enough. It doesnt even mention how to create a database. I tried looking at the examples, unfortunately, the examples …

Read More
Multiple access to a single SQLite database file via System.Data.SQLite and c#

As I can read from SQLite FAQ it supports multiple processes reading (SELECT) and only one process writing (INSERT, UPDATE, DELETE) database at any moment in time: SQLite uses reader/writer locks to control access to the database. When any …

Read More