1、引入sqlsugar的nugat包

2、封装一个操作类（参考sqlsugar官方文档）

    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(sqlSugar);//这边是SqlSugarScope用AddSingleton         }     }

3、配置program.cs和appsettings

program.cs加上下面代码

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

 appsettings配置连接字符串

4、新建一个控制台生成实体类

5、添加测试的controller

namespace Crud_demo02.Controllers {     [ApiController]     [Route("[controller]/[action]")]     public class TestController : ControllerBase     {         private readonly ISqlSugarClient _db;         public TestController(ISqlSugarClient db)         {             this._db = db;         }          [HttpGet]         public List GetAll()         {             bool isconnect=_db.CopyNew().Ado.IsValidConnection();             List lst =_db.Queryable().ToList();             return lst;         }     } }

6、swagger调试抛异常

7、修改csproj文件中，仅适用.net 8(参考sqlsugar官方文档) 

8、重新生成后就能正常连上数据库了

9、仍然连接不上

new SqlConnection(db.CurrentConfig.ConnectionString).Open()//原生进行测试 是否是 SqlSUgar问题

参考sqlsugar连不上sql server对应文档https://www.donet5.com/home/doc?masterId=1&typeId=1218