C# 程序中使用 SQLite 数据库

 1using System;
 2using System.Data;
 3using System.Data.SQLite;
 4
 5//C# 使用 SQLite 数据测试程序
 6public class Program
 7{
 8    public static void Main(string[] args)
 9    {
10        using (SQLiteConnection con = new SQLiteConnection("Data Source=c:\\test.db3;Pooling=true;FailIfMissing=false"))
11        {
12            //打开数据库文件 c:\\test.db3，不存在则创建
13            con.Open();
14
15            using (SQLiteCommand cmd = new SQLiteCommand())
16            {
17                cmd.Connection = con;
18
19                //检查是否存在表 test，不存在则创建
20                Boolean testTableExists = false;
21                cmd.CommandText = "SELECT * FROM sqlite_master WHERE type='table' and name='test'";
22                using(SQLiteDataReader dr = cmd.ExecuteReader())
23                {
24                    if (dr.Read())
25                    {
26                        testTableExists = true;
27                    }
28                }
29                if (!testTableExists)
30                {
31                    cmd.CommandText = "CREATE TABLE [test] (id int, name nvarchar(20))";
32                    cmd.ExecuteNonQuery();
33                }
34
35                //清空 test 表
36                cmd.CommandText = "DELETE FROM [test]";
37                cmd.ExecuteNonQuery();
38
39                //插入测试数据
40                for (int i = 1; i <= 5; i++)
41                {
42                    cmd.CommandText = string.Format("INSERT INTO [test] VALUES ({0}, '中文测试')", i);
43                    cmd.ExecuteNonQuery();
44                }
45
46                //读取数据
47                cmd.CommandText = "SELECT * FROM [test]";
48                using (SQLiteDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection))
49                {
50                    while (dr.Read())
51                    {
52                        Console.WriteLine("第{0} 条：{1}", dr.GetValue(0), dr.GetString(1));
53                    }
54                }
55            }
56        }
57
58        Console.WriteLine("Press any key to continue...");
59        Console.ReadKey();
60    }
61}