我显然需要在 ApiDemo 示例中添加一个 SQLite 演示.

I obviously need to add a SQLite demo to the ApiDemo sample.

因为我不知道什么时候会发生，这里是快速和肮脏的版本:

Since I don't know when that'll happen, here's the quick and dirty version:

但是，要使用以下代码，您必须面向 Android 2.2 或更高版本才能使用 Mono.Data.Sqlite.如果您需要针对较早的 Android 版本，则应考虑完全托管的替代品，例如 managed-sqlite.

However, to use the following code you must be targeting Android 2.2 or later to use Mono.Data.Sqlite. If you need to target an earlier Android version, you should look into a fully managed replacement, such as managed-sqlite.

此外，此示例使用 Mono.Data.Sqlite.dll，包含在 MonoDroid SDK 中.

Furthermore, this example is using Mono.Data.Sqlite.dll, which is included in the MonoDroid SDK.

首先，编辑您的项目程序集引用并添加对Mono.Data.Sqlite.dll 和System.Data.dll 的引用.

First, edit your project assembly references and add a reference for Mono.Data.Sqlite.dll and System.Data.dll.

其次，在您的源代码中，添加:

Second, within your source code, add:

using System.Data;
using Mono.Data.Sqlite;

最后，使用普通的 ADO.NET 代码:

Finally, use ye normal ADO.NET code:

string dbPath = Path.Combine (
        Environment.GetFolderPath (Environment.SpecialFolder.Personal),
        "items.db3");
bool exists = File.Exists (dbPath);
if (!exists)
    SqliteConnection.CreateFile (dbPath);
var connection = new SqliteConnection ("Data Source=" + dbPath);
connection.Open ();
if (!exists) {
    // This is the first time the app has run and/or that we need the DB.
    // Copy a "template" DB from your assets, or programmatically create one.
    var commands = new[]{
        "CREATE TABLE [Items] (Key ntext, Value ntext);",
        "INSERT INTO [Items] ([Key], [Value]) VALUES ('sample', 'text')"
    };
    foreach (var command in commands) {
        using (var c = connection.CreateCommand ()) {
            c.CommandText = command;
            c.ExecuteNonQuery ();
        }
    }
}
// use `connection`...
// here, we'll just append the contents to a TextView
using (var contents = connection.CreateCommand ()) {
    contents.CommandText = "SELECT [Key], [Value] from [Items]";
    var r = contents.ExecuteReader ();
    while (r.Read ())
        MyTextView.Text += string.Format ("
	Key={0}; Value={1}",
                r ["Key"].ToString (), r ["Value"].ToString ());
}
connection.Close ();