-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathSqlSugarHelper.cs
48 lines (40 loc) · 1.57 KB
/
SqlSugarHelper.cs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
public class SqlSugarHelper //不能是泛型类
{
//多库情况下使用说明:
//如果是固定多库可以传 new SqlSugarScope(List<ConnectionConfig>,db=>{}) 文档:多租户
//如果是不固定多库 可以看文档Saas分库
//用单例模式
public static SqlSugarScope Db = new SqlSugarScope(new List<ConnectionConfig>()
{
new ConnectionConfig()
{
ConfigId = 1,
ConnectionString="Server=0.0.0.0:5236;User Id=SYSDBA;PWD=SYSDBA;SCHEMA=test;DATABASE=DAMENG",
DbType= DbType.Dm,
IsAutoCloseConnection=true,
},
new ConnectionConfig()
{
ConfigId = 2,
ConnectionString="server=0.0.0.0;Database=test;Uid=root;Pwd=test;AllowLoadLocalInfile=true; ",
DbType= DbType.MySql,
IsAutoCloseConnection=true,
}
},
db =>
{
//(A)全局生效配置点,一般AOP和程序启动的配置扔这里面 ,所有上下文生效
//调试SQL事件,可以删掉
db.Aop.OnLogExecuting = (sql, pars) =>
{
//获取原生SQL推荐 5.1.4.63 性能OK
Console.WriteLine(UtilMethods.GetNativeSql(sql, pars));
//获取无参数化SQL 对性能有影响,特别大的SQL参数多的,调试使用
//Console.WriteLine(UtilMethods.GetSqlString(DbType.SqlServer,sql,pars))
};
//多个配置就写下面
//db.Ado.IsDisableMasterSlaveSeparation=true;
//注意多租户 有几个设置几个
//db.GetConnection(i).Aop
});
}