public DataTable ExecuteQuery(IDbCommand cmd, string rdbName) { IPersistenceProvider rdb = null; if (rdbName == "") { rdb = GetDatabase().GetCopy(); } else { rdb = GetDatabase(rdbName).GetCopy(); } try { rdb.Open(); DataTable dt = rdb.AsDataTable(cmd); return(dt); } catch (Exception ex) { this.ErrorHandle(ex, null, cmd.CommandText.ToString()); } finally { rdb.Close(); } return(null); }
public static DataTable ProcessStoredProc(string storeProcName, IDataParameter[] param, string dbName, Transaction transaction) { IPersistenceProvider rdb = transaction.GetPersistenceProvider(dbName); IDbCommand cmd = Query.StoredProcCommand(storeProcName, param, dbName, transaction); return(rdb.AsDataTable(cmd)); }
public static DataTable ExecuteSQLQuery(string strSQL, string dbName, int timeout, Transaction transaction) { IPersistenceProvider rdb = transaction.GetPersistenceProvider(dbName); IDbCommand cmd = rdb.GetCommand(); cmd.CommandText = strSQL; if (timeout >= 0) { cmd.CommandTimeout = timeout; } return(rdb.AsDataTable(cmd)); }
public DataTable Execute(Transaction transaction) { StringWriter sql = new StringWriter(); RenderSelect(sql); Assert.VerifyNotNull(sql, Error.NotNull); IPersistenceProvider rdb = transaction.GetPersistenceProvider(m_ClassMap.Database.Name); IDbCommand cmd = rdb.GetCommand(); cmd.CommandText = sql.ToString(); DataTable dt = rdb.AsDataTable(cmd); return(dt); }