private static void UpdateUsingEF() { var watch = Stopwatch.StartNew(); using (var dbct = new DemoDbContext(_connectionString)) { var rows = dbct.Rows.ToList(); foreach (var row in rows) { row.Column2 = "abc"; row.Column3 = DateTime.Now; } dbct.SaveChanges(); } watch.Stop(); Console.WriteLine(watch.Elapsed); }
private static void InsertUsingEF(int numberOfRows) { var watch = Stopwatch.StartNew(); using (var dbct = new DemoDbContext(_connectionString)) { var rows = new List <Row>(); for (int i = 0; i < numberOfRows; i++) { rows.Add(new Row { Column1 = i, Column2 = "" + i, Column3 = DateTime.Now }); } dbct.Rows.AddRange(rows); dbct.SaveChanges(); } watch.Stop(); Console.WriteLine(watch.Elapsed); }