static void InsertOrder( string shipName, string shipAddress, string shipCity, string shipRegionm, string shipPostalCode, string shipCountry, string customerID = null, int? employeeID = null, DateTime? orderDate = null, DateTime? requiredDate = null, DateTime? shippedDate = null, int? shipVia = null, decimal? freight = null) { using (NORTHWNDEntities context = new NORTHWNDEntities()) { Order newOrder = new Order { ShipAddress = shipAddress, ShipCity = shipCity, ShipCountry = shipCountry, ShipName = shipName, ShippedDate = shippedDate, ShipPostalCode = shipPostalCode, ShipRegion = shipRegionm, ShipVia = shipVia, EmployeeID = employeeID, OrderDate = orderDate, RequiredDate = requiredDate, Freight = freight, CustomerID = customerID }; context.Orders.Add(newOrder); context.SaveChanges(); Console.WriteLine("Row is inserted."); } }
static void Main() { using (NORTHWNDEntities northwindEntities1 = new NORTHWNDEntities()) { using (NORTHWNDEntities northwindEntities2 = new NORTHWNDEntities()) { Customer editedCustomer1 = northwindEntities1.Customers.Find("WELLI"); editedCustomer1.Region = "SP1"; Customer editedCustomer2 = northwindEntities2.Customers.Find("WELLI"); editedCustomer2.Region = "SP2"; northwindEntities1.SaveChanges(); northwindEntities2.SaveChanges(); } } }