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