C#调用Sqlite

1.加载nuget包：Install-Package Microsoft.Data.Sqlite
2.连接数据库文件如果没有会自动创建

 string dbFile= "test.db";string connString = $"Data Source={dbFile}";using (SqliteConnection conn = new SqliteConnection(connString)) {conn.Open();Console.WriteLine("SQLite数据库已连接");}

3.创建Users表

 string createTableSql = "CREATE TABLE IF NOT EXISTS Users (Id INTEGER PRIMARY KEY AUTOINCREMENT, Name TEXT, Age INTEGER)";using (SqliteCommand cmd = new SqliteCommand(createTableSql, conn)){cmd.ExecuteNonQuery();Console.WriteLine("Users表已创建");}

4.插入数据

 string insertSql = "INSERT INTO Users (Name, Age) VALUES (@Name, @Age)";using (SqliteCommand cmd = new SqliteCommand(insertSql, conn)){cmd.Parameters.AddWithValue("@Name", "Tom");cmd.Parameters.AddWithValue("@Age", 30);cmd.ExecuteNonQuery();cmd.Parameters.Clear();cmd.Parameters.AddWithValue("@Name","Jerry");cmd.Parameters.AddWithValue("@Age",31);cmd.ExecuteNonQuery();Console.WriteLine("数据已插入");}

5.查询数据

 string selectQuery = "select * from Users";using (SqliteCommand cmd =new SqliteCommand(selectQuery,conn))using (SqliteDataReader reader=cmd.ExecuteReader()){Console.WriteLine("查询结果：");while (reader.Read()){Console.WriteLine($"Id:{reader["Id"]},Name:{reader["Name"]},Age:{reader["Age"]}");}}

6.完整代码

static void Main(string[] args)
{string dbFile= "test.db";string connString = $"Data Source={dbFile}";using (SqliteConnection conn = new SqliteConnection(connString)) {conn.Open();Console.WriteLine("SQLite数据库已连接");string createTableSql = "CREATE TABLE IF NOT EXISTS Users (Id INTEGER PRIMARY KEY AUTOINCREMENT, Name TEXT, Age INTEGER)";using (SqliteCommand cmd = new SqliteCommand(createTableSql, conn)){cmd.ExecuteNonQuery();Console.WriteLine("Users表已创建");}string insertSql = "INSERT INTO Users (Name, Age) VALUES (@Name, @Age)";using (SqliteCommand cmd = new SqliteCommand(insertSql, conn)){cmd.Parameters.AddWithValue("@Name", "Tom");cmd.Parameters.AddWithValue("@Age", 30);cmd.ExecuteNonQuery();cmd.Parameters.Clear();cmd.Parameters.AddWithValue("@Name","Jerry");cmd.Parameters.AddWithValue("@Age",31);cmd.ExecuteNonQuery();Console.WriteLine("数据已插入");}string selectQuery = "select * from Users";using (SqliteCommand cmd =new SqliteCommand(selectQuery,conn))using (SqliteDataReader reader=cmd.ExecuteReader()){Console.WriteLine("查询结果：");while (reader.Read()){Console.WriteLine($"Id:{reader["Id"]},Name:{reader["Name"]},Age:{reader["Age"]}");}}conn.Close();}Console.WriteLine("执行完毕，请按任何键退出。。。");Console.ReadKey();
}