Win8 sqlite 数据库在 winrt 中的使用

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);
                     }
             }
         }
 }

Last edited Oct 14, 2011 at 8:57 AM by slonzok, version 7