static void TestOneToMany()
{
Console.WriteLine("One to many association");
using (Model2Container context = new Model2Container())
{
Console.WriteLine("Please type the person's name.");
string firstName = ReadAndValidateStringInput(10);
Console.WriteLine("Please type the person's city.");
string city = ReadAndValidateStringInput(10);
Console.WriteLine("Please type the value of the first order.");
double firstValue = Convert.ToDouble(Console.ReadLine());
Console.WriteLine("Please type the value of the second order.");
double secondValue = Convert.ToDouble(Console.ReadLine());
Customer c = new Customer()
{
Name = firstName,
City = city
};
Order o1 = new Order()
{
TotalValue = firstValue,
Date = DateTime.Now,
Customer = c
};
Order o2 = new Order()
{
TotalValue = secondValue,
Date = DateTime.Now,
Customer = c
};
context.Customers.Add(c);
context.Orders.Add(o1);
context.Orders.Add(o2);
context.SaveChanges();
var items = context.Customers;
foreach (var x in items)
{
Console.WriteLine("Customer: {0}, {1}, {2}", x.CustomerId, x.Name, x.City);
foreach (var ox in x.Orders)
{
Console.WriteLine("\tOrders: {0}, {1}, {2}", ox.OrderId, ox.Date, ox.TotalValue);
}
}
}
}
static void TesTOneToMany()
{
Console.WriteLine("One to many association");
using (Model2Container context =
new Model2Container())
{
Customer c = new Customer()
{
Name = "Customer 1",
City = "Iasi"
};
Order o1 = new Order()
{
TotalValue = 200,
Date = DateTime.Now,
Customer = c
};
Order o2 = new Order()
{
TotalValue = 300,
Date = DateTime.Now,
Customer = c
};
context.CustomerSet.Add(c);
context.OrderSet.Add(o1);
context.OrderSet.Add(o2);
context.SaveChanges();
var items = context.CustomerSet;
foreach (var x in items)
{
Console.WriteLine("Customer : {0}, {1}, {2}",
x.CustomerId, x.Name, x.City);
foreach (var ox in x.Order)
{
Console.WriteLine("\tOrders: {0}, {1}, {2}",
ox.OrderId, ox.Date, ox.TotalValue);
}
}
}
}
