安装sqlite
下载地址:https://www.sqlite.org/download.html
安装教程:https://www.runoob.com/sqlite/sqlite-installation.html
C#连接数据库
1. 添加dll(使用本地添加)
步骤一:右键引用,单击管理NuGet程序包,如下图
步骤二:查找sqlite相关程序包,添加如图所示程序包
2.编程实现对数据库的操作。
class sqliteclass
{
/// <summary>
/// 连接数据库
/// </summary>
/// <returns></returns>
public SQLiteConnection getSQLiteConnection()
{
string sqlConString = "Data Source=F:/CAD/projec/testslitedb/sqlitedatabass/testdb.db;Version=3;FailIfMissing=True";
SQLiteConnection conn = new SQLiteConnection(sqlConString);
return conn;
}
/// <summary>
/// 数据库查询操作
/// </summary>
/// <param name="sqlStr">可执行的sql查询语句</param>
/// <returns>返回数据库的查询结果</returns>
public SQLiteDataReader getData(string sqlStr)
{
DataColumn column = new DataColumn();
SQLiteConnection conn = getSQLiteConnection();
conn.Open();
SQLiteCommand command = new SQLiteCommand(sqlStr, conn);
SQLiteDataReader reader = command.ExecuteReader();
return reader;
}
/// <summary>
/// debug调试显示
/// </summary>
/// <param name="sqlStr"></param>
public void debug_showTable(string sqlStr)
{
SQLiteDataReader reader = this.getData(sqlStr);
System.Diagnostics.Debug.WriteLine("----:start");
while (reader.Read())
{
for(int i=0; i< reader.FieldCount;i++)
{
System.Diagnostics.Debug.Write(reader[i]+" ");
}
System.Diagnostics.Debug.WriteLine(" ");
}
System.Diagnostics.Debug.WriteLine("----:over");
}
}