.net8+webapi+sqlsugar基本配置；“连接数据库过程中发生错误，检查服务器是否正常连接字符串是否正确”异常

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