public EFExec(int[] rowsArray, FilmSerie filmSerie, FilmSerie newFilmSerie)
{
this.filmSerie = filmSerie;
this.newFilmSerie = newFilmSerie;
int idCounter = 0;
totalMs = 0;
using (NetflaxContext dbContext = new NetflaxContext())
{
// Saves the database before testing
dbContext.Genre.Add(new Genre()
{
Name = "name"
});
dbContext.SaveChanges();
}
foreach (int rows in rowsArray)
{
Console.WriteLine("For {0} rows: ", rows);
long result = Insert(rows);
totalMs += result;
Console.Write("\rInsert: ");
Console.WriteLine(result + " milisecons");
result = Select(rows);
totalMs += result;
Console.Write("\rSelect: ");
Console.WriteLine(result + " milisecons");
result = Update(rows, idCounter);
totalMs += result;
Console.Write("\rUpdate: ");
Console.WriteLine(result + " milisecons");
result = Delete(rows, idCounter);
totalMs += result;
Console.Write("\rDelete: ");
Console.WriteLine(result + " milisecons");
idCounter += rows;
}
Console.WriteLine();
Console.WriteLine("Total of {0}ms", totalMs);
}
private long Select(int rows)
{
var watch = Stopwatch.StartNew();
using (NetflaxContext dbContext = new NetflaxContext())
{
var set = dbContext.FilmsSeries;
Console.Write("Selecting");
// Do something with the data
foreach (FilmSerie filmSerie in set)
{
FilmSerie filmSerie1 = filmSerie;
int percent = (int)((filmSerie.ID / rows) * 100);
Console.Write("\rSelecting {0}%", percent);
}
}
watch.Stop();
return(watch.ElapsedMilliseconds);
}
