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