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