private static void LoadTeamWithAthletes() { var sw = new Stopwatch(); var ef = new EFAccessor(); var dapper = new DapperAccessor(); long[] teamIds; using (var db = new Context()) { teamIds = db.Set <Team>().Select(team => team.Id).ToArray(); } sw.Start(); ef.FindTeamWithAthletes(teamIds[0]); sw.Stop(); Console.WriteLine("EF find Team with Athletes first: {0}", sw.ElapsedMilliseconds); sw.Restart(); ef.FindTeamWithAthletes(teamIds[1]); sw.Stop(); Console.WriteLine("EF find Team with Athletes second: {0}", sw.ElapsedMilliseconds); sw.Restart(); dapper.FindTeamWithAthletes(teamIds[2]); sw.Stop(); Console.WriteLine("Dapper find Team with Athletes first: {0}", sw.ElapsedMilliseconds); sw.Restart(); dapper.FindTeamWithAthletes(teamIds[0]); sw.Stop(); Console.WriteLine("Dapper find Team with Athletes second: {0}", sw.ElapsedMilliseconds); }
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); }
private static void InsertAthletes() { var sw = new Stopwatch(); var ef = new EFAccessor(); var dapper = new DapperAccessor(); var athlete = new Athlete { FirstName = Guid.NewGuid().ToString(), LastName = Guid.NewGuid().ToString(), Position = Guid.NewGuid().ToString(), }; sw.Start(); ef.SaveAthlete(athlete); sw.Stop(); Console.WriteLine("EF save Athlete first: {0}", sw.ElapsedMilliseconds); athlete = new Athlete { FirstName = Guid.NewGuid().ToString(), LastName = Guid.NewGuid().ToString(), Position = Guid.NewGuid().ToString(), }; sw.Restart(); ef.SaveAthlete(athlete); sw.Stop(); Console.WriteLine("EF save Athlete second: {0}", sw.ElapsedMilliseconds); athlete = new Athlete { FirstName = Guid.NewGuid().ToString(), LastName = Guid.NewGuid().ToString(), Position = Guid.NewGuid().ToString(), }; sw.Restart(); dapper.SaveAthlete(athlete); sw.Stop(); Console.WriteLine("Dapper save Athlete first: {0}", sw.ElapsedMilliseconds); athlete = new Athlete { FirstName = Guid.NewGuid().ToString(), LastName = Guid.NewGuid().ToString(), Position = Guid.NewGuid().ToString(), }; sw.Restart(); dapper.SaveAthlete(athlete); sw.Stop(); Console.WriteLine("Dapper save Athlete second: {0}", sw.ElapsedMilliseconds); }
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); }
private static void LoadTeamWithAthletes() { var sw = new Stopwatch(); var ef = new EFAccessor(); var dapper = new DapperAccessor(); long[] teamIds; using (var db = new Context()) { teamIds = db.Set<Team>().Select(team => team.Id).ToArray(); } sw.Start(); ef.FindTeamWithAthletes(teamIds[0]); sw.Stop(); Console.WriteLine("EF find Team with Athletes first: {0}", sw.ElapsedMilliseconds); sw.Restart(); ef.FindTeamWithAthletes(teamIds[1]); sw.Stop(); Console.WriteLine("EF find Team with Athletes second: {0}", sw.ElapsedMilliseconds); sw.Restart(); dapper.FindTeamWithAthletes(teamIds[2]); sw.Stop(); Console.WriteLine("Dapper find Team with Athletes first: {0}", sw.ElapsedMilliseconds); sw.Restart(); dapper.FindTeamWithAthletes(teamIds[0]); sw.Stop(); Console.WriteLine("Dapper find Team with Athletes second: {0}", sw.ElapsedMilliseconds); }