public TimeSpan createQueries(int count) { Stopwatch stopWatch = new Stopwatch(); stopWatch.Start(); int max = 1000; using (var connection = new EFHandler()) { List <User> users = new List <User>(); for (int idx = 0; idx < count; idx++) { User user = new User() { email = "*****@*****.**", created_at = DateTime.Now }; users.Add(user); connection.users.Add(user); if (idx % max == 0 || idx == (count - 1)) { connection.SaveChanges(); foreach (User user2 in users) { connection.Entry(user2).State = EntityState.Detached; } users.Clear(); } } } stopWatch.Stop(); return(stopWatch.Elapsed); }
public TimeSpan updateQueries(int count) { Stopwatch stopWatch = new Stopwatch(); stopWatch.Start(); using (var connection = new EFHandler()) { List <User> users = connection.users.Take(count).ToList(); foreach (User user in users) { user.failedLoginAttempts = 1; } connection.SaveChanges(); } stopWatch.Stop(); return(stopWatch.Elapsed); }
public TimeSpan deleteQueries(int count) { Stopwatch stopWatch = new Stopwatch(); stopWatch.Start(); using (var connection = new EFHandler()) { List <User> users = connection.users.Take(count).ToList(); foreach (User user in users) { connection.users.Remove(user); } connection.SaveChanges(); } stopWatch.Stop(); return(stopWatch.Elapsed); }