Exemple #1
0
        private static void LoadAthletesForPosition()
        {
            var sw        = new Stopwatch();
            var random    = new Random();
            var positions = new string[] { "Punter", "Pitcher", "Keeper", "First Base" };
            var ef        = new EFAccessor();
            var dapper    = new DapperAccessor();

            sw.Start();
            ef.FindByPosition(positions[0]);
            sw.Stop();
            Console.WriteLine("EF find by Position first: {0}", sw.ElapsedMilliseconds);

            sw.Restart();
            ef.FindByPosition(positions[1]);
            sw.Stop();
            Console.WriteLine("EF find by Position second: {0}", sw.ElapsedMilliseconds);

            sw.Restart();
            var athletes = dapper.FindByPosition(positions[2]);

            sw.Stop();
            Console.WriteLine("Dapper find by Position second: {0}", sw.ElapsedMilliseconds);

            sw.Restart();
            dapper.FindByPosition(positions[3]);
            sw.Stop();
            Console.WriteLine("Dapper find by Position second: {0}", sw.ElapsedMilliseconds);
        }
Exemple #2
0
        private static void LoadAthletesForPosition()
        {
            var sw = new Stopwatch();
            var random = new Random();
            var positions = new string[] { "Punter", "Pitcher", "Keeper", "First Base" };
            var ef = new EFAccessor();
            var dapper = new DapperAccessor();

            sw.Start();
            ef.FindByPosition(positions[0]);
            sw.Stop();
            Console.WriteLine("EF find by Position first: {0}", sw.ElapsedMilliseconds);

            sw.Restart();
            ef.FindByPosition(positions[1]);
            sw.Stop();
            Console.WriteLine("EF find by Position second: {0}", sw.ElapsedMilliseconds);

            sw.Restart();
            var athletes = dapper.FindByPosition(positions[2]);
            sw.Stop();
            Console.WriteLine("Dapper find by Position second: {0}", sw.ElapsedMilliseconds);

            sw.Restart();
            dapper.FindByPosition(positions[3]);
            sw.Stop();
            Console.WriteLine("Dapper find by Position second: {0}", sw.ElapsedMilliseconds);
        }