public OracleDBPoolUtil() { DBPools = new Dictionary <string, OleExecPool>(); ConnectionManager.Init(); String sfcConnectString = ConnectionManager.GetConnString("SFCORACLEDB"); OleExecPool sfcPool = new OleExecPool(sfcConnectString); DBPools.Add("SFCDB", sfcPool); }
/// <summary> /// 構造一個OleExec對象,該對象用於執行SQL語句等任務 /// </summary> /// <param name="strConn"></param> public OleExec(string strConn, OleExecPool _Pool) { _connStr = strConn; _conn = new OleDbConnection(_connStr); _conn.Open(); _comm = new OleDbCommand(); _adp = new OleDbDataAdapter(_comm); Pool = _Pool; }
/// <summary> /// 構造一個OleExec對象,該對象用於執行SQL語句等任務 /// </summary> /// <param name="strConn"></param> public OleExec(string strConn, OleExecPool _Pool) { _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(); Pool = _Pool; }