indexertest.cs

Professional C# 2nd Edition

using System;
using System.Data.SqlClient;

public class SimpleSelect
{
	public static int Main(string[] args)
	{
		string        source = Login.Connection ;

		string        select = "SELECT CategoryID,CategoryName FROM Categories" ;

		using ( SqlConnection conn = new SqlConnection ( source ) )
		{
			conn.Open() ;

			SqlCommand    cmd = new SqlCommand ( select , conn ) ;

			SqlDataReader aReader = cmd.ExecuteReader ( ) ;

			aReader.Read ( ) ;

			// Now time access to the first field in the reader...
			long timeInitial , timeElapsed , iterations , maxIterations = 1000000;

			int   theCategoryID ;

			timeInitial = DateTime.Now.Ticks ;

			for ( iterations = 0 ; iterations < maxIterations ; iterations++ )
				theCategoryID = (int) aReader[0] ;

			timeElapsed = DateTime.Now.Ticks ;    

			Console.WriteLine ( "{0} iterations using numeric indexer : {1}s" , 
				iterations ,
				new TimeSpan ( timeElapsed - timeInitial ) ) ;

			timeInitial = DateTime.Now.Ticks ;

			for ( iterations = 0 ; iterations < maxIterations ; iterations++ )
				theCategoryID = (int) aReader["CategoryID"] ;

			timeElapsed = DateTime.Now.Ticks ;    

			Console.WriteLine ( "{0} iterations using textual indexer : {1}s" , 
				iterations ,
				new TimeSpan ( timeElapsed - timeInitial )  ) ;

			timeInitial = DateTime.Now.Ticks ;

			for ( iterations = 0 ; iterations < maxIterations ; iterations++ )
				theCategoryID = aReader.GetInt32 (0);

			timeElapsed = DateTime.Now.Ticks ;    

			Console.WriteLine ( "{0} iterations using GetInt32(0)     : {1}s" , 
				iterations ,
				new TimeSpan ( timeElapsed - timeInitial )  ) ;

			conn.Close ( ) ;

			return 0;
		}
	}
}