private static void AddOrder(Order order, Order_Detail orderDetail) { using (NorthwndEntities context = new NorthwndEntities()) { using (TransactionScope transaction = new TransactionScope()) { context.Orders.Add(order); context.SaveChanges(); orderDetail.OrderID = context.Orders.Where(x => x.ShipName == "Last ship").First().OrderID; context.Order_Details.Add(orderDetail); context.SaveChanges(); transaction.Complete(); } } }
static void Main(string[] args) { Order order = new Order { CustomerID = "BLONP", OrderDate = DateTime.Now, ShipCountry = "Bulgaria", ShipName = "Last ship" }; Order_Detail orderDetail = new Order_Detail { ProductID = 5, Quantity = 10, Discount = 0 }; AddOrder(order, orderDetail); }