37 lines
1.3 KiB
C#
37 lines
1.3 KiB
C#
|
using SqlSugar;
|
|||
|
using System;
|
|||
|
using System.Linq;
|
|||
|
|
|||
|
namespace APPUpgradeAPI
|
|||
|
{
|
|||
|
public class BaseDB
|
|||
|
{
|
|||
|
public static SqlSugarClient GetClient()
|
|||
|
{
|
|||
|
try
|
|||
|
{
|
|||
|
string ConnStr = BaseDBConfig.GetConfig("ConnectionStrings:DB");
|
|||
|
SqlSugarClient db = new SqlSugarClient(
|
|||
|
new ConnectionConfig()
|
|||
|
{
|
|||
|
ConnectionString = ConnStr,
|
|||
|
DbType = DbType.SqlServer,
|
|||
|
IsAutoCloseConnection = true,//自动释放数据务,如果存在事务,在事务结束后释放
|
|||
|
InitKeyType = InitKeyType.Attribute//从实体特性中读取主键自增列信息
|
|||
|
}
|
|||
|
);
|
|||
|
db.Aop.OnLogExecuting = (sql, pars) =>
|
|||
|
{
|
|||
|
string sqlText = sql + "\r\n" + db.Utilities.SerializeObject(pars.ToDictionary(it => it.ParameterName, it => it.Value));
|
|||
|
Console.WriteLine(sql + "\r\n" + db.Utilities.SerializeObject(pars.ToDictionary(it => it.ParameterName, it => it.Value)));
|
|||
|
Console.WriteLine();
|
|||
|
};
|
|||
|
return db;
|
|||
|
}
|
|||
|
catch (Exception ex)
|
|||
|
{
|
|||
|
throw ex;
|
|||
|
}
|
|||
|
}
|
|||
|
}
|
|||
|
}
|