首先，从这个网站下载SQLite的XXXXXXT驱动。

XXXXXXXXXXXXXXXXXXXXXXXXXXXXX/XXXXXXXXml/doc/trunk/www/downloads.wiki

推荐下载这个版本：

Precompiled Statically-Linked Binaries for 32-bit Windows (.NET Framework 2.0 SP2)

sqlite-netFx20-static-binary-bundle-Win32-2005-1.0.102.0.zip

使用SQLite需要将C#的架构改成x86，不能用Any CPU。

XXXXXXnfig改成这样，不然在新版.NET中会加载失败。

<code class="language-xml"><?xml version="1.0" encoding="utf-8" ?>
<configuration>
    <startup uselegacyv2runtimeactivationpolicy="true"> 
        <supportedruntime version="v4.0.30319">
        <supportedruntime version="v2.0.50727">
    </supportedruntime></supportedruntime></startup>
</configuration>
</code>

如果不想改XXXXXXnfig可以下载这个，不过.net3.5及以下版本就不能用了：

Precompiled Statically-Linked Binaries for 32-bit Windows (.NET Framework 4.0)

sqlite-netFx40-static-binary-bundle-Win32-2010-1.0.102.0.zip

使用时添加System.Data.SQLite.dll的引用就行了，不需要做其它事情。

使用示例代码如下，连接时如果文件不存在则会自动创建文件。

<code class="language-cs">using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.Common;
using System.Data.SQLite;

namespace sqlitetest
{
    class Program
    {
        static void Main(string[] args)
        {
            using (DbConnection conn = new SQLiteConnection("Data Source = test.db"))
            {
                conn.Open();
                using (DbCommand cmd = conn.CreateCommand())
                {
                    cmd.CommandText = "CREATE TABLE IF NOT EXISTS student(id integer, name varchar(20), sex varchar(2));";
                    cmd.ExecuteNonQuery();

                    cmd.CommandText = "INSERT INTO student VALUES(1, '小红', '男')";
                    cmd.ExecuteNonQuery();
                    cmd.CommandText = "INSERT INTO student VALUES(2, '小李', '女')";
                    cmd.ExecuteNonQuery();
                    cmd.CommandText = "INSERT INTO student VALUES(3, '小明', '男')";
                    cmd.ExecuteNonQuery();

                    cmd.CommandText = "SELECT * FROM student";
                    using (DbDataReader dr = cmd.ExecuteReader())
                    {
                        while (dr.Read())
                        {
                            Console.WriteLine(dr.GetInt32(0));
                            Console.WriteLine(dr.GetString(1));
                            Console.WriteLine(dr.GetString(2));
                        }
                    }
                }
            }
        }
    }
}
</code>