private static void BulkInsert(NorthwindModel context)
{
List<Product> products = new List<Product>(50000);
for (int i = 0; i < 30000; i++)
{
Product product = new Product() { ProductName = "Lexus" + i, SupplierID = 5, CategoryID = 5, UnitPrice = 1000m, QuantityPerUnit = "1 piece" };
products.Add(product);
}
context.Add(products);
context.SaveChanges();
}
private static void SlowDelete(NorthwindModel context)
{
context.Delete(context.Products.Where(p => p.ProductID % 7 == 2));
context.SaveChanges();
}