64 lines
2.5 KiB
C#
64 lines
2.5 KiB
C#
using SqlSugar;
|
||
using System;
|
||
using System.Collections.Generic;
|
||
using System.Diagnostics;
|
||
using System.Linq;
|
||
using System.Text;
|
||
using System.Threading.Tasks;
|
||
using static WebSocketToolsConsole.Entity;
|
||
|
||
namespace TestWebSocket
|
||
{
|
||
public class SqlSugarBase
|
||
{
|
||
public static SqlSugarScope FaceDb = new SqlSugarScope(new ConnectionConfig()
|
||
{
|
||
DbType = SqlSugar.DbType.MySql,
|
||
ConnectionString = "Server=blv-cloud-db.mysql.rds.aliyuncs.com;Database=face;Uid=blv_rcu;Pwd=fnadiaJDIJ7546;charset=utf8;port=3307;",
|
||
IsAutoCloseConnection = true //不设成true要手动close
|
||
},
|
||
db =>
|
||
{
|
||
//(A)全局生效配置点，一般AOP和程序启动的配置扔这里面 ，所有上下文生效
|
||
//调试SQL事件，可以删掉
|
||
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)
|
||
|
||
};
|
||
});
|
||
|
||
public static SqlSugarScope RcuDb = new SqlSugarScope(new ConnectionConfig()
|
||
{
|
||
DbType = SqlSugar.DbType.MySql,
|
||
ConnectionString = "Server=blv-cloud-db.mysql.rds.aliyuncs.com;Database=blv_rcu_db;Uid=blv_rcu;Pwd=fnadiaJDIJ7546;charset=utf8;port=3307;",
|
||
IsAutoCloseConnection = true //不设成true要手动close
|
||
});
|
||
|
||
public static SqlSugarClient FaceDbClient()
|
||
{
|
||
SqlSugarClient Db = new SqlSugarClient(new ConnectionConfig()
|
||
{
|
||
ConnectionString = "Server=blv-cloud-db.mysql.rds.aliyuncs.com;Database=Face;Uid=blv_rcu;Pwd=fnadiaJDIJ7546;charset=utf8;port=3307;",
|
||
DbType = SqlSugar.DbType.MySql,
|
||
InitKeyType = InitKeyType.Attribute,//从特性读取主键和自增列信息
|
||
IsAutoCloseConnection = true,//开启自动释放模式和EF原理一样我就不多解释了
|
||
});
|
||
//用来打印Sql方便调式
|
||
Db.Aop.OnLogExecuting = (sql, pars) =>
|
||
{
|
||
Db.Utilities.SerializeObject(pars.ToDictionary(it => it.ParameterName, it => it.Value));
|
||
Debug.WriteLine(sql);
|
||
};
|
||
return Db;
|
||
}
|
||
|
||
}
|
||
}
|