SqlSugarHelper封装以及使用 返回
SqlSugar
处理完成
1
400

悬赏:0 飞吻
public class SqlSugarHelper { public static SqlSugarClient Db = new SqlSugarClient(new ConnectionConfig { ConnectionString = ConfigurationManager.ConnectionStrings["Conn"].ConnectionString, DbType = DbType.SqlServer, IsAutoCloseConnection = true, MoreSettings = new ConnMoreSettings { IsWithNoLockQuery = true } }, db => { db.Aop.OnLogExecuting = (sql, pars) => { //Console.WriteLine(sql); //输出sql,查看执行sql 性能无影响 //获取原生SQL推荐 5.1.4.63 性能OK //Console.WriteLine(UtilMethods.GetNativeSql(sql, pars)); #if DEBUG //获取无参数化SQL 对性能有影响,特别大的SQL参数多的,调试使用 Console.WriteLine("执行SQL语句::" + UtilMethods.GetNativeSql(sql, pars)); #endif }; }); }
其他调用的地方都类似以下调用,想知道这样是否正确,希望避免偶发性错误
SqlSugarHelper.Db.CopyNew().Queryable<Invoice>().InSingle(id);
热忱回答(1)
-
fate sta VIP0
2024/7/31SqlSugarClient 禁止单例
0 回复