C# sqlite 数据库

1.依赖项

• Dapper
• System.Data.SQLite.Core

2.主要应用

1. 初始化数据库

private static string dbPath = @"D:\apidb\dcb.db";//数据库文件
private string connStr = "data source=" + dbPath;//数据源
//...
 #region 初始化数据库
private void InitSQLiteDb()
 {
    //数据库存在则跳过
    if (System.IO.File.Exists(dbPath))
    {
        return;
    }
    using (var conn = new SQLiteConnection(connStr))
    {
        conn.Execute(@"
            CREATE TABLE ProductInfo (
            Id INTEGER PRIMARY KEY AUTOINCREMENT,
            Product TEXT NOT NULL,
            Panel TEXT NOT NULL,
            OK TEXT NOT NULL,
            NG TEXT NOT NULL,
            TimeReceive TEXT
            )");
        }
    }
    #endregion
    #region 测试插入数据
    private string Insert(ProductData pd)
    {
        using (var cn = new SQLiteConnection(connStr))
        {
            //参数 MSSQL 和 SQLite 使用 @paramName ，Oracle 使用 :paramName
            timeReceive = DateTime.Now.ToString();
            var insertScript = "INSERT INTO ProductInfo VALUES (@Id,@Product, @Panel, @OK, @NG,'"+timeReceive+"')";
            try
            {
                result =  cn.Execute(insertScript, pd).ToString();
            }
            catch (Exception ex)
            {}
        }
        return result;
    }
    #endregion