You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
51 lines
1.9 KiB
C#
51 lines
1.9 KiB
C#
using DS.Module.Core;
|
|
using DS.Module.Core.Extensions;
|
|
using DS.Module.Core.Modules;
|
|
using Microsoft.Extensions.DependencyInjection;
|
|
using Microsoft.Extensions.Logging;
|
|
using SqlSugar;
|
|
|
|
namespace DS.Module.SqlSugar;
|
|
/// <summary>
|
|
/// SqlSugar模块
|
|
/// </summary>
|
|
public class SqlSugarModule : DSAppModule
|
|
{
|
|
/// <summary>
|
|
/// 数据库连接字符串
|
|
/// </summary>
|
|
private static string DbInfo = AppSetting.Configuration["ConnectionStrings:DbInfo"];
|
|
/// <summary>
|
|
/// 数据库类型
|
|
/// </summary>
|
|
private static string DbType = AppSetting.Configuration["ConnectionStrings:DbType"];
|
|
|
|
private ILogger<SqlSugarModule> _logger;
|
|
public override void ConfigureServices(ConfigureServicesContext context)
|
|
{
|
|
_logger = context.Services.GetService<ILogger<SqlSugarModule>>();
|
|
SqlSugarScope sqlSugar = new SqlSugarScope(new ConnectionConfig()
|
|
{
|
|
DbType = DbType.ToEnum<DbType>(),
|
|
ConnectionString = DbInfo,
|
|
IsAutoCloseConnection = true,
|
|
InitKeyType = InitKeyType.Attribute,
|
|
// AopEvents=aop
|
|
},
|
|
db =>
|
|
{
|
|
//单例参数配置，所有上下文生效
|
|
db.Ado.CommandTimeOut = 30;
|
|
db.Aop.OnLogExecuting = (sql, pars) =>
|
|
{
|
|
_logger.Log(LogLevel.Information, DateTime.Now.ToString() + "\r\n" + sql + "\r\n" + db.Utilities.SerializeObject(pars.ToDictionary(it => it.ParameterName, it => it.Value)));
|
|
};
|
|
db.Aop.OnError = (exp) => //执行SQL 错误事件
|
|
{
|
|
_logger.Log(LogLevel.Error, DateTime.Now.ToString() + "\r\n" + exp.Sql + "\r\n" + exp.Parametres);
|
|
};
|
|
});
|
|
|
|
context.Services.AddSingleton<ISqlSugarClient>(sqlSugar); //这边是SqlSugarScope用AddSingleton
|
|
}
|
|
} |