private static void BulkInsert() { using (EntitiesModel context = new EntitiesModel()) { List<Product> productsNew = new List<Product>(); for (int i = 0; i < 1000; i++) { productsNew.Add(new Product() { Discontinued = false, ProductName = "Product" + i }); } context.Add(productsNew); context.SaveChanges(); } }
private static MemoryStream SerializeToBinaryStream(string customerId) { BinaryFormatter formatter = new BinaryFormatter(); MemoryStream stream = new MemoryStream(); using (EntitiesModel dbContext = new EntitiesModel()) { Customer customer = dbContext.Customers.Where(c => c.CustomerID == customerId).First(); formatter.Serialize(stream, customer); } return stream; }
private static TimeSpan SlowDelete() { using (EntitiesModel context = new EntitiesModel()) { Stopwatch watch = new Stopwatch(); var customersToRemove = from product in context.Products where (product.ProductID > 80) select product; watch.Start(); context.Delete(customersToRemove); //context.Delete(context.Products.Where(p => p.ProductID % 7 == 2 && p.ProductID > 80)); context.SaveChanges(); watch.Stop(); return watch.Elapsed; } }
static void Main() { // Task 1 Customer customer = new Customer(); customer.PropertyChanged += Write; customer.Address = "ba"; // Task 2 var serializedStream = SerializeToBinaryStream("ALFKI"); // Task 3 BulkInsert(); TimeSpan timeToDeleteSlow = SlowDelete(); using (EntitiesModel context = new EntitiesModel()) { var query = from product in context.Products where (product.SupplierID == null) select customer; query.DeleteAll(); } }