static void Main(string[] args) { Customer newCustmer = new Customer(); newCustmer.CustomerID = "KULO"; newCustmer.CompanyName = "Mala"; newCustmer.ContactName = "Misoto Kulano"; newCustmer.ContactTitle = "Owner"; newCustmer.Address = "Amela str 23"; newCustmer.City = "Pelon"; newCustmer.PostalCode = "1231"; newCustmer.Country = "France"; newCustmer.Phone = "3443-4323-432"; newCustmer.Fax = "3245-243"; using (var otherDataBase = new NorthwindEntities()) { using (var dataBase = new NorthwindEntities()) { otherDataBase.Customers.Add(newCustmer); otherDataBase.SaveChanges(); dataBase.Customers.Attach(newCustmer); dataBase.Customers.Remove(newCustmer); dataBase.SaveChanges(); } } }
private static void AddThreeOrdersUsingTransaction() { // Note: max lenght of shipCity is 15. string[] shipCityNames = { "Persepolis", "Cartagen", "Chargoggagoggmanchauggagoggchaubunagungamaugg Lake" }; using (TransactionScope scope = new TransactionScope()) { using (NorthwindEntities context = new NorthwindEntities()) { try { foreach (var shipCity in shipCityNames) { Order order = new Order { ShipCity = shipCity }; context.Orders.Add(order); context.SaveChanges(); } scope.Complete(); } catch (DbEntityValidationException deve) { DbEntityValidationResult result = deve.EntityValidationErrors.First(); DbValidationError error = result.ValidationErrors.First(); Console.WriteLine("Invalid order property: {0}", error.PropertyName); } } } }