1. 在C#安装System.Data.SQLite
在NuGet程序包内,搜索System.Data.Sqlite,安装Sqlite类库
x64和x86文件夹中存放
2. 实现代码
static void Main(string[] args) {
SQLiteConnection conn = null;
string dbPath = "Data Source =" + Environment.CurrentDirectory + "/test.db3";
conn = new SQLiteConnection(dbPath);//创建数据库实例,指定文件位置
conn.Open();//打开数据库,若文件不存在会自动创建
string sql = "CREATE TABLE IF NOT EXISTS student(id integer, name varchar(20), sex varchar(2));";//建表语句
SQLiteCommand cmdCreateTable = new SQLiteCommand(sql, conn);
cmdCreateTable.ExecuteNonQuery();//如果表不存在,创建数据表
SQLiteCommand cmdInsert = new SQLiteCommand(conn);
cmdInsert.CommandText = "INSERT INTO student VALUES(1, '小红', '男')";//插入几条数据
cmdInsert.ExecuteNonQuery();
cmdInsert.CommandText = "INSERT INTO student VALUES(2, '小李', '女')";
cmdInsert.ExecuteNonQuery();
cmdInsert.CommandText = "INSERT INTO student VALUES(3, '小明', '男')";
cmdInsert.ExecuteNonQuery();
conn.Close();
Console.WriteLine("ok");
}
3. 数据库查看
SQLite Expert
https://www.sqliteexpert.com/download.html