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); }