public static SqlSugarClient GetInstance() { var db = new SqlSugarClient( new ConnectionConfig() { ConnectionString = Config.GetConfig().SqlString2, // "Data Source=47.107.186.141;Initial Catalog=db;User ID=sa;Password=jiangxinji.123", DbType = DbType.MySql, //设置数据库类型 IsAutoCloseConnection = true, //自动释放数据务,如果存在事务,在事务结束后释放 InitKeyType = InitKeyType.Attribute //从实体特性中读取主键自增列信息 }); var mq = new RabbitMQDomain(); db.Aop.OnLogExecuted = (sql, pars) => //SQL执行完事件 { foreach (var p in pars) { string s = ""; if (p.DbType == System.Data.DbType.String) { s = $"\'{p.Value}\'"; } else if (p.DbType == System.Data.DbType.DateTime || p.DbType == System.Data.DbType.Date || p.DbType == System.Data.DbType.DateTime2) { if (string.IsNullOrEmpty(Convert.ToString(p.Value))) { s = $"\'{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")}\'"; } else { var dt = Convert.ToDateTime(p.Value); s = $"\'{dt.ToString("yyyy-MM-dd HH:mm:ss")}\'"; } } else { s = Convert.ToString(p.Value); } if (string.IsNullOrEmpty(s)) { s = "\'\'"; } sql = sql.Replace(p.ParameterName, s); } mq.Producter(sql); }; try { db.Open(); } catch { db = GetInstance2(); } return(db); }
public static SqlSugarClient GetInstance() { SqlSugarClient db = new SqlSugarClient(new ConnectionConfig() { ConnectionString = ConnectionString, DbType = DbType.MySql, IsAutoCloseConnection = false, InitKeyType = InitKeyType.Attribute }); db.Open(); return(db); }
/// <summary> /// 连接状态 /// </summary> public static bool OnlineState() { try { sqlSugarClient.Open(); sqlSugarClient.Close(); return(true); } catch (Exception ex) { _logger.Error("连接数据库失败", ex); return(false); } }
public OleExec(string strConn) { _connStr = strConn; //_conn = new OleDbConnection(_connStr); //_conn.Open(); //_comm = new OleDbCommand(); //_adp = new OleDbDataAdapter(_comm); db = new SqlSugarClient(new ConnectionConfig() { ConnectionString = _connStr, DbType = SqlSugar.DbType.Oracle, IsAutoCloseConnection = false, InitKeyType = InitKeyType.Attribute }); db.Open(); }
/** * 建立連線 */ public bool Connect() { bool ret = false; try { // 建立連線 sql.Open(); ret = true; SaveLog($"[Info] Connect Data Base Success"); } catch (Exception ex) { SaveLog($"[Error] DataBaseConnect::Connect, Connect Data Base Fail, Catch Msg: {ex.Message}"); } return(ret); }
/** * 建立連線 */ public bool Connect() { bool bReturn = false; try { // 建立連線 sql.Open(); bReturn = true; log.SaveLog("Connect SQL Success"); } catch (Exception ex) { log.SaveLog("[Error] DataBaseConnect::Connect SQL Connect Fail, Error Msg:" + ex.Message); } return bReturn; }
private static void SqlSugarClient() { //Create db Console.WriteLine("#### SqlSugarClient Start ####"); SqlSugarClient db = new SqlSugarClient(new ConnectionConfig() { DbType = DbType.Kdbndp, ConnectionString = Config.ConnectionString, InitKeyType = InitKeyType.Attribute, IsAutoCloseConnection = true, AopEvents = new AopEvents { OnLogExecuting = (sql, p) => { Console.WriteLine(sql); Console.WriteLine(string.Join(",", p?.Select(it => it.ParameterName + ":" + it.Value))); } } }); db.Open(); //If no exist create datebase db.DbMaintenance.CreateDatabase(); //Use db query var dt = db.Ado.GetDataTable("select 1"); //Create tables db.CodeFirst.InitTables(typeof(OrderItem), typeof(Order)); var id = db.Insertable(new Order() { Name = "order1", CustomId = 1, Price = 0, CreateTime = DateTime.Now }).ExecuteReturnIdentity(); //Insert data db.Insertable(new OrderItem() { OrderId = id, Price = 0, CreateTime = DateTime.Now }).ExecuteCommand(); Console.WriteLine("#### SqlSugarClient End ####"); }
public override bool ValidConnection() { string dbConnStr = $"Data Source={this.server}/{this.dataBase};User ID={this.userName};Password={this.password};"; try { SqlSugarClient Db = new SqlSugarClient(new ConnectionConfig() { ConnectionString = dbConnStr, DbType = DbType.Oracle, IsAutoCloseConnection = true, //设为true,表示相同线程是同一个SqlSugarClient IsShardSameThread = true }); Db.Open(); return(true); } catch (Exception ex) { throw new BusinessException((int)EnumSystemStatusCode.DME_ERROR, "数据库验证失败,详情:" + ex.Message); } }