static void RunExample() { using (var context = new EFRecipesEntities()) { // static order status var assemble = new OrderStatus { OrderStatusId = 1, Status = "Assemble" }; var test = new OrderStatus { OrderStatusId = 2, Status = "Test" }; var ship = new OrderStatus { OrderStatusId = 3, Status = "Ship" }; context.OrderStatus.AddObject(assemble); context.OrderStatus.AddObject(test); context.OrderStatus.AddObject(ship); var order = new Order { Description = "HAL 9000 Supercomputer", OrderStatus = assemble }; context.Orders.AddObject(order); context.SaveChanges(); order.OrderStatus = ship; try { context.SaveChanges(); } catch (Exception) { Console.WriteLine("Oops...better test first."); } order.OrderStatus = test; context.SaveChanges(); order.OrderStatus = ship; context.SaveChanges(); } using (var context = new EFRecipesEntities()) { foreach (var order in context.Orders) { Console.WriteLine("Order {0} [{1}], status = {2}", order.OrderId.ToString(), order.Description, order.OrderStatus.Status); } } Console.WriteLine("Press any key to close..."); Console.ReadLine(); }
static void Cleanup() { using (var context = new EFRecipesEntities()) { context.ExecuteStoreCommand("delete from chapter12.[order]"); context.ExecuteStoreCommand("delete from chapter12.orderstatus"); } }