static void DisplayLineItems() { bool found = false; using (var context = new Recipe7Context()) { foreach (var lineitem in context.LineItems) { Console.WriteLine("Line item: Cost {0}", lineitem.Cost.ToString("C")); found = true; } } if (!found) { Console.WriteLine("No line items found!"); } }
public static void Run() { using (var context = new Recipe7Context()) { var invoice1 = new Invoice { BilledTo = "Julie Kerns", InvoiceDate = DateTime.Parse("9/19/2013") }; var invoice2 = new Invoice { BilledTo = "Jim Stevens", InvoiceDate = DateTime.Parse("9/21/2013") }; var invoice3 = new Invoice { BilledTo = "Juanita James", InvoiceDate = DateTime.Parse("9/23/2013") }; context.LineItems.Add(new LineItem { Cost = 99.29M, Invoice = invoice1 }); context.LineItems.Add(new LineItem { Cost = 29.95M, Invoice = invoice1 }); context.LineItems.Add(new LineItem { Cost = 109.95M, Invoice = invoice2 }); context.LineItems.Add(new LineItem { Cost = 49.95M, Invoice = invoice3 }); context.SaveChanges(); // display the line items Console.WriteLine("Original set of line items..."); DisplayLineItems(); // remove a line item from invoice 1's collection var item = invoice1.LineItems.ToList().First(); invoice1.LineItems.Remove(item); context.SaveChanges(); Console.WriteLine("\nAfter removing a line item from an invoice..."); DisplayLineItems(); // remove invoice2 context.Invoices.Remove(invoice2); context.SaveChanges(); Console.WriteLine("\nAfter removing an invoice..."); DisplayLineItems(); // remove a single line item context.LineItems.Remove(invoice1.LineItems.First()); context.SaveChanges(); Console.WriteLine("\nAfter removing a line item..."); DisplayLineItems(); // update a single line item var item2 = invoice3.LineItems.ToList().First(); item2.Cost = 39.95M; context.SaveChanges(); Console.WriteLine("\nAfter updating a line item from an invoice …"); DisplayLineItems(); } }