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);
}
private static IDbCommand StoredProcCommand(string storedProcName, IDataParameter[] param, string dbName, Transaction transaction)
{
IPersistenceProvider rdb = transaction.GetPersistenceProvider(dbName);
IDbCommand cmd = rdb.GetCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = storedProcName;
if (param != null)
{
for (int intlop = 0; intlop < param.Length; intlop++)
{
IDataParameter parameter = param[intlop];
cmd.Parameters.Add(parameter);
}
}
return(cmd);
}
public static IDataParameter GetParameter(string dbName, Transaction transaction)
{
IPersistenceProvider rdb = transaction.GetPersistenceProvider(dbName);
return(rdb.GetCommand().CreateParameter());
}
