using Document.Unility;
|
using Microsoft.Extensions.Configuration;
|
using Microsoft.Extensions.DependencyInjection;
|
using SqlSugar;
|
|
namespace DocumentServiceAPI.Core
|
{
|
public static class SqlsugarSetup
|
{
|
public static void AddSqlsugarSetup(this IServiceCollection services, IConfiguration configuration, string dbName = "sqldb")
|
{
|
//如果多个数数据库传 List<ConnectionConfig>
|
var configConnection = new ConnectionConfig()
|
{
|
DbType = SqlSugar.DbType.SqlServer,
|
ConnectionString = configuration.GetConnectionString(dbName),
|
IsAutoCloseConnection = true,
|
};
|
|
SqlSugarScope sqlSugar = new SqlSugarScope(configConnection,
|
db =>
|
{
|
//单例参数配置，所有上下文生效
|
db.Aop.OnLogExecuting = (sql, pars) =>
|
{
|
//Console.WriteLine(sql);//输出sql
|
};
|
//SQL报错
|
db.Aop.OnError = (exp) =>
|
{
|
NLogProvider.GetInstance().Error(exp);
|
};
|
});
|
|
services.AddSingleton<ISqlSugarClient>(sqlSugar);//这边是SqlSugarScope用AddSingleton
|
}
|
}
|
}
|
