首先建一个类
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();
}
搞定