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