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);
}
