Exemple #1
0
        private static void LoadOneAthlete()
        {
            var sw     = new Stopwatch();
            var random = new Random();
            var id     = random.Next(3000);
            var ef     = new EFAccessor();
            var dapper = new DapperAccessor();

            sw.Start();
            ef.FindAthlete(id);
            sw.Stop();
            Console.WriteLine("EF find by Id first: {0}", sw.ElapsedMilliseconds);

            id = random.Next(3000);
            sw.Reset();

            sw.Start();
            ef.FindAthlete(id);
            sw.Stop();
            Console.WriteLine("EF find by Id second: {0}", sw.ElapsedMilliseconds);

            id = random.Next(3000);
            sw.Reset();

            sw.Start();
            dapper.FindAthlete(id);
            sw.Stop();
            Console.WriteLine("Dapper find by Id first: {0}", sw.ElapsedMilliseconds);

            id = random.Next(3000);
            sw.Reset();

            sw.Start();
            dapper.FindAthlete(id);
            sw.Stop();
            Console.WriteLine("Dapper find by Id second: {0}", sw.ElapsedMilliseconds);
        }
Exemple #2
0
        private static void LoadOneAthlete()
        {
            var sw = new Stopwatch();
            var random = new Random();
            var id = random.Next(3000);
            var ef = new EFAccessor();
            var dapper = new DapperAccessor();

            sw.Start();
            ef.FindAthlete(id);
            sw.Stop();
            Console.WriteLine("EF find by Id first: {0}", sw.ElapsedMilliseconds);

            id = random.Next(3000);
            sw.Reset();

            sw.Start();
            ef.FindAthlete(id);
            sw.Stop();
            Console.WriteLine("EF find by Id second: {0}", sw.ElapsedMilliseconds);

            id = random.Next(3000);
            sw.Reset();

            sw.Start();
            dapper.FindAthlete(id);
            sw.Stop();
            Console.WriteLine("Dapper find by Id first: {0}", sw.ElapsedMilliseconds);

            id = random.Next(3000);
            sw.Reset();

            sw.Start();
            dapper.FindAthlete(id);
            sw.Stop();
            Console.WriteLine("Dapper find by Id second: {0}", sw.ElapsedMilliseconds);
        }