/// <summary>
/// Simple prepare query with no parameters
/// </summary>
/// <param name="sql"></param>
public void PrepareReader(
DbCommandMx drd,
string sql)
{
if (BuildSqlOnly)
{
Qe.AddSqlToSqlStatementList(this, sql);
}
else
{
DateTime t0 = DateTime.Now;
drd.Prepare(sql, DbType.String, 0);
double dt = TimeOfDay.Delta(t0);
ExecuteReaderTime += dt;
//ExecuteReaderCount++;
}
return;
}
/// <summary>
/// Prepare query with string parameters
/// </summary>
/// <param name="drd"></param>
/// <param name="sql"></param>
/// <param name="stringParameterCount"></param>
public void PrepareMultipleParameterReader(
DbCommandMx drd,
string sql,
int stringParameterCount)
{
if (BuildSqlOnly)
{
Qe.AddSqlToSqlStatementList(this, sql);
}
else
{
DateTime t0 = DateTime.Now;
drd.Prepare(sql, OracleDbType.Varchar2, stringParameterCount);
double dt = TimeOfDay.Delta(t0);
ExecuteReaderTime += dt;
//ExecuteReaderCount++;
}
return;
}
/// <summary>
/// Open a list reader
/// </summary>
/// <param name="list"></param>
public void ExecuteListReader(
DbCommandMx drd,
List <string> list)
{
if (BuildSqlOnly)
{
string sql = drd.ListSql; // sql with list item place holder
Qe.AddSqlToSqlStatementList(this, sql);
}
else
{
DateTime t0 = DateTime.Now;
drd.ExecuteListReader(list);
double dt = TimeOfDay.Delta(t0);
ExecuteReaderTime += dt;
ExecuteReaderCount++;
}
return;
}
