I got a few questions and comments about how to actually include SQLite in a C# Metro style app. Since perhaps it wasn’t clear in describing in my post, I thought a quick video might help demonstrate the steps to build and use SQLite in a C# Metro style app.
The video walks through actually building SQLite from the source (Visual Studio 2012 required…express is fine) and adding it to a C# Metro style app, create a database, populate with some data based on a class and databind the query to a ListView. The video references my OneNote notebook on the tools you need to download and build the SQLite source. It also demonstrates using the sqlite-net library from NuGet on interacting with SQLite in a C# application.
This is a quick video to demonstrate the concept on how to get started and is not a full end-to-end sample.
NOTE: This video only demonstrates how to build SQLite until the team itself merges the WinRT changes and produces the supported build. Until then this is a step you’d have to do on your own and these private branches are not fully supported by them until merged to their main release branch.
I hope this helps clarify things!