liaoxujun@qq.com
2023-09-07 876292b5a092977ac84c1c1699d9f3e45b9be67d
DocumentServiceAPI.Core/DbContext.cs
@@ -45,7 +45,7 @@
               db.CurrentConnectionConfig.ConfigureExternalServices = new ConfigureExternalServices()
               {
                   //判断是否开启redis设置二级缓存方式
                 //  DataInfoCacheService = new SqlSugarRedisCache(),
                   DataInfoCacheService = new SqlSugarRedisCache(),
                   //模型定义为 int?号时自动为可空
                   EntityService = (c, p) =>
                   {
@@ -59,6 +59,19 @@
                   }
               };
               db.Aop.OnLogExecuting = (sql, pars) =>
               {
                   Console.WriteLine(sql);//输出sql,查看执行sql 性能无影响
                   //获取原生SQL推荐 5.1.4.63  性能OK
                   //UtilMethods.GetNativeSql(sql,pars)
                   //获取无参数化SQL 对性能有影响,特别大的SQL参数多的,调试使用
                   //UtilMethods.GetSqlString(DbType.SqlServer,sql,pars)
               };
               db.CurrentConnectionConfig.MoreSettings = new ConnMoreSettings()
               {
                   //所有 增、删 、改 会自动调用.RemoveDataCache()清理二级缓存