SqlSugar链接数据库 读取appsetting中配置的链接字符串

首先建一个类

using SqlSugar;


namespace PayManagerCore.Filter
{
	public class SqlSugarHelper
	{
		private static readonly Lazy<SqlSugarClient> _db = new Lazy<SqlSugarClient>(() =>
		{
			IConfigurationRoot configuration = new ConfigurationBuilder()
				.SetBasePath(AppDomain.CurrentDomain.BaseDirectory)
				.AddJsonFile("appsettings.json")
				.Build();

			string connectionString = configuration.GetConnectionString("sqlcon");

			var db = new SqlSugarClient(new ConnectionConfig()
			{
				ConnectionString = connectionString,
				DbType = DbType.MySql, // 根据实际情况修改数据库类型
				InitKeyType = InitKeyType.Attribute,
                IsAutoCloseConnection = true
            });

			return db;
		});
		public static SqlSugarClient DB => _db.Value;
	}
}

然后 appsetting.json中配置你的链接字符串

{
  "Logging": {
    "LogLevel": {
      "Default": "Information",
      "Microsoft.AspNetCore": "Warning"
    }
  },
  "AllowedHosts": "*",
  "ConnectionStrings": {
    "sqlcon": "server=.;uid=123;pwd=123;database=mysql01",
  
  }
}

然后控制器中这样调用

：SqlSugarHelper.DB

 if (SqlSugarHelper.DB.Queryable<UserInfo>().First(it => it.name == username) == null)
 {
     ViewBag.notice = "用户名不存在";
     return View();
 }

搞定