.Net6 WebApi使用SqlSugar

1、Nuget先引入：SqlSugarCore

2、Net IOC

1、注入ISqlSugarClient

.NET自带的IOC使用也很方便 

先封装一个操作类

 

//建一个扩展类
public static class SqlsugarSetup
{
    public static void AddSqlsugarSetup(this IServiceCollection services, IConfiguration configuration, 
    string dbName = "db_master")
    {
        SqlSugarScope sqlSugar = new SqlSugarScope(new ConnectionConfig()
        {
            DbType = SqlSugar.DbType.SqlServer,
            ConnectionString = configuration.GetConnectionString(dbName),
            IsAutoCloseConnection = true,
        },
            db =>
            {
                //单例参数配置，所有上下文生效
                db.Aop.OnLogExecuting = (sql, pars) =>
                {
                    //Console.WriteLine(sql);//输出sql
                };
                //技巧：拿到非ORM注入对象
                //services.GetService<注入对象>();
            });
        services.AddSingleton<ISqlSugarClient>(sqlSugar);//这边是SqlSugarScope用AddSingleton
    }
}
//Startup.cs或者Program 文件添加下面代码
//services.AddSqlsugarSetup(Configuration);

2、 Program.cs中的配置

 

builder.Services.AddSqlsugarSetup(builder.Configuration, "db_master");

 

 

 这里的db_master如果有默认值可以不写。

注意的地方：

appsettings.json 文件中一定要加 ConnectionStrings 包一下，否则会报数据库链接字符串错误。

 

 "ConnectionStrings": {
    "db_master": "Data Source=.;Initial Catalog=WApp;Persist Security Info=True;User ID=sa;Password=123456"
  }

 

3、新建一个Controller 来测试一下

 

　　 [Route("api/[controller]/[action]")]
    [ApiController]
    public class DbTstController : ControllerBase
    {
        private readonly ISqlSugarClient _db;
        public DbTstController(ISqlSugarClient db)
        {
            this._db = db;
        }

        [HttpGet]
        public List<SysUser> GetSysUserList()
        {
            List<SysUser> lst = _db.Queryable<SysUser>().ToList();
            return lst;
        }
    }