BabyVideoService/Db/DB.cs

using SqlSugar;

namespace ACBuildService;

public static class DB
{
    public static SqlSugarClient Main { get; private set; }

    public static void InitDb()
    {
        //创建数据库对象 (用法和EF Dappper一样通过new保证线程安全)
        Main = new SqlSugarClient(new ConnectionConfig()
            {
                ConnectionString = "datasource=data.db",
                DbType = DbType.Sqlite,
                IsAutoCloseConnection = true
            },
            db =>
            {
                // db.Aop.OnLogExecuting = (sql, pars) =>
                // {
                //     //获取原生SQL推荐 5.1.4.63  性能OK
                //     Console.WriteLine(UtilMethods.GetNativeSql(sql, pars));
                // };
            });

        //建库
        Main.DbMaintenance.CreateDatabase();

        //建表
        Main.CodeFirst.InitTables<VideoTable>();
        Main.CodeFirst.InitTables<DeviceTable>();
        Main.CodeFirst.InitTables<ConfigTable>();
    }
}