protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
{
optionsBuilder.UseSqlServer(ConfigurationUtilities.GetConnectionStringFromConnectionKey("OrdersDB"));
}
private static async Task Main(string[] args)
{
string connectionString = ConfigurationUtilities.GetConnectionStringFromConnectionKey("ProductsDb");
var productsOptionsBuilder = new DbContextOptionsBuilder();
productsOptionsBuilder.UseSqlServer(connectionString);
var productsRespository = new ProductRepository(new ProductContext());
var material1 = new Material("Some-Material1", "Some-Description1", 2.50M);
var material2 = new Material("Some-Material2", "Some-Description2", 4.75M);
var material3 = new Material("Some-Material3", "Some-Description3", 7.25M);
var partList1 = new List <ProductPart>
{
new ProductPart("Some-Part1", "grams", 1.0M, new List <Material> {
material1, material3
}),
new ProductPart("Some-Part2", "grams", 3.0M, new List <Material> {
material2, material3
}),
};
var partList2 = new List <ProductPart>
{
new ProductPart("Some-Part1", "grams", 6.0M, new List <Material> {
material1, material3
}),
new ProductPart("Some-Part3", "grams", 5.0M, new List <Material> {
material2, material3, material1
}),
};
var product1 = new Product
{
Name = "Some-Product1",
ProductParts = partList1
};
productsRespository.Insert(product1);
await productsRespository.SaveChangesAsync();
var product2 = new Product
{
Name = "Some-Product2",
ProductParts = partList2
};
productsRespository.Insert(product2);
await productsRespository.SaveChangesAsync();
var products = productsRespository.GetProducts();
var ordersRepository = new OrderRepository(new OrderContext());
var order1 = new Order
{
Items = new List <OrderItem>
{
new OrderItem
{
ProductId = product1.Id,
Quantity = 3,
UnitPrice = 5
}
},
OrderDate = DateTime.Now
};
ordersRepository.Insert(order1);
await ordersRepository.SaveChangesAsync();
var order2 = new Order
{
Items = new List <OrderItem>
{
new OrderItem
{
ProductId = product2.Id,
Quantity = 3,
UnitPrice = 5
}
},
OrderDate = DateTime.Now
};
ordersRepository.Insert(order2);
await ordersRepository.SaveChangesAsync();
var order3 = new Order
{
Items = new List <OrderItem>
{
new OrderItem
{
ProductId = product2.Id,
Quantity = 9,
UnitPrice = 2
}
},
OrderDate = DateTime.Now
};
ordersRepository.Insert(order3);
await ordersRepository.SaveChangesAsync();
var orders = ordersRepository.GetOrders();
}