Local database storage for WinRT/Metro applications

database windows-runtime windows-store-apps microsoft-metro local-storage
Martin Robins picture Martin Robins · Feb 18, 2012 · Viewed 11.4k times · Source

I am trying to find an API within WinRT that will allow me to create a local database that can be used to store data for an occasionally connected application. I am looking for something like SQL Compact Edition.

I have seen various messages on various boards indicating that there either

  • (a) will be no local databases whatsoever
  • (b) no local "server" databases (i.e. SQL Express type instances)
  • (c) A local database code named "Jet Blue".

Does anybody have a definitive answer to this? I do not want to start down this road if it is blocked.

Answer

Sergey Barskiy picture Sergey Barskiy · Jun 29, 2012

SQLite is now officially supported. See Tim Heuer's blog for details. For simpler solution with less data you can use http://winrtdatabase.codeplex.com/

Related questions

Insert into ... values ( SELECT ... FROM ... )

I am trying to INSERT INTO a table using the input from another table. Although this is entirely feasible for many database engines, I always seem to struggle to remember the correct syntax for the SQL engine of the day (…

Read More
What is the difference between "INNER JOIN" and "OUTER JOIN"?

Also how do LEFT JOIN, RIGHT JOIN and FULL JOIN fit in?

Read More
'IF' in 'SELECT' statement - choose output value based on column values

SELECT id, amount FROM report I need amount to be amount if report.type='P' and -amount if report.type='N'. How do I add this to the above query?

Read More