| | |
| | | db.CurrentConnectionConfig.ConfigureExternalServices = new ConfigureExternalServices() |
| | | { |
| | | //判断是否开启redis设置二级缓存方式 |
| | | // DataInfoCacheService = new SqlSugarRedisCache(), |
| | | DataInfoCacheService = new SqlSugarRedisCache(), |
| | | //模型定义为 int?号时自动为可空 |
| | | EntityService = (c, p) => |
| | | { |
| | |
| | | } |
| | | |
| | | }; |
| | | 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()清理二级缓存 |