/// <summary> /// DB連接對象 /// </summary> /// <param name="DBConntionConfigName">連接配置名稱</param> /// <param name="ReadXMLConfig">是否從XML配置檔讀取連接字符串</param> public OleExec(string DBConntionConfigName, bool ReadXMLConfig) { if (Pool != null && !Pool.TestBorrow(this)) { throw new Exception("OleExec havn't borrow from DBPool!"); } if (ReadXMLConfig) { ConnectionManager.Init(); _connStr = ConnectionManager.GetConnString(DBConntionConfigName); } else { _connStr = ConfigurationManager.AppSettings[DBConntionConfigName]; } //_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 }); }
/// <summary> /// DB連接對象 /// </summary> /// <param name="DBConntionConfigName">連接配置名稱</param> /// <param name="ReadXMLConfig">是否從XML配置檔讀取連接字符串</param> public OleExec(string DBConntionConfigName, bool ReadXMLConfig) { if (Pool != null && !Pool.TestBorrow(this)) { throw new Exception("OleExec havn't borrow from DBPool!"); } if (ReadXMLConfig) { ConnectionManager.Init(); _connStr = ConnectionManager.GetConnString(DBConntionConfigName); } else { _connStr = ConfigurationManager.AppSettings[DBConntionConfigName]; } _conn = new OleDbConnection(_connStr); _conn.Open(); _comm = new OleDbCommand(); _adp = new OleDbDataAdapter(_comm); }