public void RunQuery( string query, QueryResults results ) { if ( results == null ) throw new ArgumentNullException ( "results" ); try { this._progressBar.MaxIterations = IterationsToRun; this._progressBar.Reset (); long elapsedTime = 0; using ( SqlConnection myConnection = new SqlConnection ( this._connectionString ) ) { myConnection.Open (); using ( SqlCommand myCommand = new SqlCommand ( query, myConnection ) ) { this._progressBar.Reset (); for ( int iteration = 0; iteration < IterationsToRun; iteration++ ) { elapsedTime += RunQueryOnce ( results, myCommand ); this._progressBar.StepIt (); } } } this._progressBar.Finish (); results.Time = elapsedTime / IterationsToRun; results.Success = true; results.ErrorMessage = ""; } catch ( Exception ex ) { results.Time = 0; results.Success = false; results.ErrorMessage = ex.Message; } }
private static long RunQueryOnce( QueryResults results, SqlCommand myCommand ) { Stopwatch timer = new Stopwatch (); timer.Start (); SqlDataReader reader = null; myCommand.CommandTimeout = Int32.MaxValue; using ( reader = myCommand.ExecuteReader () ) { results.RowsReturned = 0; while ( reader.Read () ) { object[] rowData = new object[reader.FieldCount]; reader.GetValues ( rowData ); results.Data.Add ( rowData ); results.RowsReturned++; } } timer.Stop (); return timer.ElapsedTicks; }
public Query() { this._results = new QueryResults(); }
public Query () { this._results = new QueryResults (); }
public void RunQuery( string query, QueryResults results ) { results.Success = _shouldSucceed; results.Time = _time; }