.net Core中sqlsugar的安装和dbfirst的基本使用

1、安装

2、SqlSugar 集成--- Furion 集成

1、创建一个拓展类 SqlsugarSetup

public static class SqlsugarSetup { 
    public static void AddSqlsugarSetup(this IServiceCollection services, IConfiguration                 configuration, string dbName = "db_master") 
    { 
        //如果多个数数据库传 
        List<ConnectionConfig> var configConnection=new ConnectionConfig() 
        { 
            DbType = SqlSugar.DbType.MySql, 
            ConnectionString = configuration.GetConnectionString(dbName),         IsAutoCloseConnection = true, }; 
            SqlSugarScope sqlSugar = new SqlSugarScope(configConnection, 
                db => { 
                //单例参数配置，所有上下文生效 db.Aop.OnLogExecuting = (sql, pars) => {                                                     //Console.WriteLine(sql);//输出sql 
                }; 
            }); 
        services.AddSingleton<ISqlSugarClient>(sqlSugar);//这边是SqlSugarScope用AddSingleton 
    } 
}

2、配置数据库连接

3、program中注册服务

builder.Services.AddSqlsugarSetup(builder.Configuration);

3、利用dbfirst生成实体类

运行后会自动创建实体类