Project Description
SQLite wrapper for WinRT
Cannot compile? Read this: http://social.msdn.microsoft.com/Forums/en-US/winappswithnativecode/thread/1900bd21-8693-4127-800a-f35cfd5daac2
Example (C#):
var db = new SQLite.Database("sqlite.test"); // creates the database file in the local app folder
if (db.Ready) {
var stmt = db.PrepareStatement("CREATE TABLE IF NOT EXISTS people (name TEXT, age INTEGER)");
if (stmt.Execute()) {
stmt = db.PrepareStatement("INSERT INTO people (name, age) VALUES (?, ?)");
stmt.BindText(1, "John Smith");
stmt.BindInt(2, 33);
if (stmt.Execute()) {
stmt = db.PrepareStatement("SELECT name, age FROM people");
while (stmt.HasMore()) {
var name = stmt.ColumnAsTextAt(0);
var age = stmt.ColumnAsIntAt(1);
}
}
}
}