|
using Furion;
|
using Furion.Logging.Extensions;
|
using Microsoft.AspNetCore.Builder;
|
using Microsoft.AspNetCore.Hosting;
|
using Microsoft.Extensions.Configuration;
|
using Microsoft.Extensions.DependencyInjection;
|
using SqlSugar;
|
using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Reflection;
|
using System.Text;
|
using System.Threading.Tasks;
|
using System.Xml.Linq;
|
|
namespace CYZuoYeBenPeiSong.Core
|
{
|
public class Startup : AppStartup
|
{
|
//使用sqlsugar 数据库连接库
|
|
public void ConfigureServices(IServiceCollection services)
|
{
|
var configConnection = App.GetConfig<List<ConnectionConfig>>("DbConnect");
|
|
|
services.AddSingleton<ISqlSugarClient>(s =>
|
{
|
SqlSugarScope sqlSugar = new SqlSugarScope(configConnection,
|
db =>
|
{
|
db.CurrentConnectionConfig.ConfigureExternalServices = new ConfigureExternalServices()
|
{
|
//判断是否开启redis设置二级缓存方式
|
//DataInfoCacheService = new SqlSugarRedisCache(),
|
//模型定义为 int?号时自动为可空
|
EntityService = (c, p) =>
|
{
|
/***高版C#写法***/
|
//支持string?和string
|
if (p.IsPrimarykey == false && new NullabilityInfoContext()
|
.Create(c).WriteState is NullabilityState.Nullable)
|
{
|
p.IsNullable = true;
|
}
|
}
|
|
};
|
db.CurrentConnectionConfig.MoreSettings = new ConnMoreSettings()
|
{
|
//所有 增、删 、改 会自动调用.RemoveDataCache()清理二级缓存
|
IsAutoRemoveDataCache = true
|
};
|
db.Aop.OnError = (exp) =>
|
{
|
$"数据库执行错误了:{exp}".LogInformation();
|
// NlogUtil.WriteFileLog(NLog.LogLevel.Error, LogType.Other, "SqlSugar", "执行SQL错误事件", exp);
|
};
|
|
//单例参数配置，所有上下文生效
|
//db.Aop.OnLogExecuting = (sql, pars) =>
|
//{
|
// //获取作IOC作用域对象
|
// // var appServive = s.GetService<IHttpContextAccessor>();
|
// // var obj = appServive?.HttpContext?.RequestServices.GetService<Log>();
|
// // Console.WriteLine("AOP" + obj.GetHashCode());
|
//};
|
});
|
//sqlSugar.DbMaintenance.CreateDatabase();
|
//Type[]? types = DbCoreUntil.DbCodeFirstModes("EzCoreNetFurion.Model", thisAttribute: typeof(CoderFirstAttribute));
|
|
|
//sqlSugar.CodeFirst.InitTables(types ?? new Type[] { });
|
return sqlSugar;
|
});
|
|
|
}
|
|
public void Configure(IApplicationBuilder app, IWebHostEnvironment env)
|
{
|
|
}
|
}
|
}
|
