| | |
| | | { |
| | | get |
| | | { |
| | | //SnowFlakeSingle.WorkId = Settings.SqlSugar.SnowFlakeWorkId; 不同机器配置的唯一数字; // 单服务器不需要指定 |
| | | return new ConnectionConfig() |
| | | ConnectionConfig connectConfig = null; |
| | | switch (RepairParasHelper.Repair.DataBase.DbType) |
| | | { |
| | | DbType = SqlSugar.DbType.PostgreSQL,//数据库类型 |
| | | ConnectionString = RepairParasHelper.Repair.DataBase.PostgreSql.ConnectString, |
| | | IsAutoCloseConnection = true,//是否自动关闭 |
| | | MoreSettings = new ConnMoreSettings() |
| | | { |
| | | //PgSqlIsAutoToLower = false //数据库存在大写字段的 ,需要把这个设为false ,并且实体和字段名称要一样 |
| | | }, |
| | | AopEvents = new AopEvents |
| | | { |
| | | OnLogExecuting = (sql, p) => |
| | | case DbType.PostgreSql: |
| | | { |
| | | // var sqlString = UtilMethods.GetNativeSql(sql, p); |
| | | //LogHelper.Debug(sqlString); |
| | | // Console.WriteLine(sql); |
| | | connectConfig = PostgreSqlConnectionConfig; |
| | | } |
| | | } |
| | | }; |
| | | break; |
| | | case DbType.SQLite: |
| | | { |
| | | connectConfig = SQLiteConnectionConfig; |
| | | } |
| | | break; |
| | | default: break; |
| | | } |
| | | return connectConfig; |
| | | } |
| | | } |
| | | |