- 安装所需要的nuget包
SqlSugar
MySql.Data
- 在Program.cs文件全局注入sqlsugar
builder.Services.AddScoped<SqlSugarClient>(provider => new SqlSugarClient(new ConnectionConfig
{
ConnectionString = "请填入数据库连接字符串配置",
DbType = DbType.MySql,
IsAutoCloseConnection = true,
InitKeyType = InitKeyType.Attribute
}));
- 在控制器构造函数中使用
public class ApiService:IApiService
{
private readonly SqlSugarClient _db;
public ApiService(SqlSugarClient db)
{
_db = db;
}
}
注:下面代码是获取appsettings.json配置文件里名为“DbConnectionString”的字符串连接串
builder.Configuration.GetConnectionString("DbConnectionString")
appsettings.json文件这样写
{
"Logging": {
"LogLevel": {
"Default": "Information",
"Microsoft.AspNetCore": "Warning"
}
},
"AllowedHosts": "*",
"ConnectionStrings": {
"DbConnectionString": "Data Source=localhost;Database=imp;AllowLoadLocalInfile=true;User ID=root;Password=123456;allowPublicKeyRetrieval=true;pooling=true;CharSet=utf8;port=3306;sslmode=none;"
}
}
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)