SqlSugarDBContext.cs
1.32 KB
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
using Hh.Mes.Common.log;
using SqlSugar;
using System;
using System.Collections.Generic;
using System.Configuration;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace HH.Data.Excel
{
public class SqlSugarDBContext
{
public SqlSugarClient GetInstance()
{
string connectionString = ConfigurationManager.ConnectionStrings["BaseDBContext"].ConnectionString;
var db = new SqlSugarClient(new ConnectionConfig()
{
// 数据库连接字符串
ConnectionString = connectionString,
DbType = DbType.SqlServer, // 根据实际情况选择数据库类型
IsAutoCloseConnection = true, // 自动关闭连接
InitKeyType = InitKeyType.Attribute // 从实体属性中读取主键
});
// 可选：启用日志记录，方便调试
db.Aop.OnLogExecuting = (sql, pars) =>
{
Console.WriteLine(sql);
Log4NetHelper.Instance.Info("InitLog4Net Init Failed");
};
return db;
}
public List<T> Queryable<T>() where T : class, new()
{
using (var db = GetInstance())
{
return db.Queryable<T>().ToList();
}
}
}
}