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