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 EF()
{
startingComments();
efHandler = new EFHandler();
inserting();
selecting();
updating();
deleting();
}
public int countRows()
{
int amount = 0;
using (var connection = new EFHandler())
{
amount = connection.users.Count();
}
return(amount);
}
public TimeSpan selectQueries(int count)
{
Stopwatch stopWatch = new Stopwatch();
stopWatch.Start();
using (var connection = new EFHandler())
{
List <User> users = connection.users.Take(count).ToList();
}
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);
}