public void BasicDynamicDataReaderTimerTest() { var data = new SqlDataAccess("server=.;database=WestwindWebStore_Client;integrated security=true;"); dynamic reader = data.ExecuteDynamicDataReader("select * from wws_items"); Assert.IsNotNull(reader, "Query Failure: " + data.ErrorMessage); StringBuilder sb = new StringBuilder(); Stopwatch watch = new Stopwatch(); watch.Start(); while (reader.Read()) { string sku = reader.Sku; string descript = reader.Descript; decimal?price = reader.Price; sb.AppendLine(sku + " " + descript + " " + price.Value.ToString("n2")); } watch.Stop(); reader.Close(); Console.WriteLine(watch.ElapsedMilliseconds.ToString()); Console.WriteLine(sb.ToString()); }
public void ExecuteDynamicDataReaderTest() { using (var data = new SqlDataAccess(STR_ConnectionString)) { var swatch = Stopwatch.StartNew(); var reader = data.ExecuteDynamicDataReader( "select * from ApplicationLog where entered > @0 and entered < @1 order by Entered", DateTime.Now.AddYears(-115), DateTime.Now.AddYears(-1)); Assert.IsNotNull(reader, data.ErrorMessage); while (reader.Read()) { Console.WriteLine(reader.Entered); } swatch.Stop(); Console.WriteLine(swatch.ElapsedMilliseconds + "ms"); } }