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;
|
|
}
|
|
}
|
|
}
|
|
} |