private void InsertSeedData() { var products = CreateProducts(_productCount, setPrimaryKeys: false); using (var context = new OrdersContext(_connectionString)) { context.Products.AddRange(products); context.SaveChanges(); } var customers = CreateCustomers(_customerCount, setPrimaryKeys: false); using (var context = new OrdersContext(_connectionString)) { context.Customers.AddRange(customers); context.SaveChanges(); } var orders = CreateOrders(customers, _ordersPerCustomer, setPrimaryKeys: false); using (var context = new OrdersContext(_connectionString)) { context.Orders.AddRange(orders); context.SaveChanges(); } var lines = CreateOrderLines(products, orders, _linesPerOrder, setPrimaryKeys: false); using (var context = new OrdersContext(_connectionString)) { context.OrderLines.AddRange(lines); context.SaveChanges(); } }
private static void Insert(TestHarness harness) { using (var context = new OrdersContext(_connectionString)) { using (context.Database.BeginTransaction()) { for (var i = 0; i < 1000; i++) { context.Customers.Add(new Customer { Name = "New Customer " + i }); } harness.StartCollection(); var records = context.SaveChanges(); harness.StopCollection(); Assert.Equal(1000, records); } } }
private static void Update(TestHarness harness) { using (var context = new OrdersContext(_connectionString)) { using (context.Database.BeginTransaction()) { foreach (var customer in context.Customers) { customer.Name += " Modified"; } harness.StartCollection(); var records = context.SaveChanges(); harness.StopCollection(); Assert.Equal(1000, records); } } }
public void InsertSeedData( string connectionString, int productCount, int customerCount, int ordersPerCustomer, int linesPerOrder) { var products = CreateProducts(productCount); using (var context = new OrdersContext(connectionString)) { context.Products.AddRange(products); context.SaveChanges(); } var customers = CreateCustomers(customerCount); using (var context = new OrdersContext(connectionString)) { context.Customers.AddRange(customers); context.SaveChanges(); } var orders = CreateOrders(ordersPerCustomer, customers); using (var context = new OrdersContext(connectionString)) { context.Orders.AddRange(orders); context.SaveChanges(); } var lines = CreateOrderLines(linesPerOrder, products, orders); using (var context = new OrdersContext(connectionString)) { context.OrderLines.AddRange(lines); context.SaveChanges(); } }
private static void Mixed(TestHarness harness) { using (var context = new OrdersContext(_connectionString)) { using (context.Database.BeginTransaction()) { var customers = context.Customers.ToArray(); for (var i = 0; i < 333; i++) { context.Customers.Add(new Customer { Name = "New Customer " + i }); } for (var i = 0; i < 1000; i += 3) { context.Customers.Remove(customers[i]); } for (var i = 1; i < 1000; i += 3) { customers[i].Name += " Modified"; } harness.StartCollection(); var records = context.SaveChanges(); harness.StopCollection(); Assert.Equal(1000, records); } } }