c# 配置 sqlsugar

1. 工具》NUGET包管理器 》 管理解决方案的NUGET程序包 在打开的界面下载 sqlsugar.core

2. 新建 sql.cs

using SqlSugar;

public static class SqlSugarSetup
{
    public static void AddSqlSugarSetup(this IServiceCollection services, IConfiguration configuration, string dbName = "DefaultConnection")
    {
        var sqlSugar = new SqlSugarScope(new ConnectionConfig()
        {
            ConnectionString = configuration.GetConnectionString(dbName),
            DbType = DbType.SqlServer,
            IsAutoCloseConnection = true,
            InitKeyType = InitKeyType.Attribute
        },
        db =>
        {
            // AOP 配置（可选）
            db.Aop.OnLogExecuting = (sql, pars) =>
            {
                Console.WriteLine(sql); // 输出执行的SQL语句
            };
        });

        services.AddSingleton<ISqlSugarClient>(sqlSugar);
    }
}

3.appsetting.json配置

"ConnectionStrings": {
  "DefaultConnection": "Server=服务地址加端口（端口用逗号分开）;Database=数据库名称;User Id=账号;Password=密码;Encrypt=True;TrustServerCertificate=True"
}

4.入口文件引入并注册

 builder.Services.AddSqlSugarSetup(builder.Configuration);