static void Main() { NorthwindEntities db = new NorthwindEntities(); //using (db) //{ // foreach (var customer in db.Customers) // { // Console.WriteLine(customer.Country); // } //} //NorthwindDao.CloneDatabaseSchema(); // NorthwindDao.FindCustomersByOrderYearAndCountry(5, "fas"); //NorthwindDao.TryConcurrentChanges(); //NorthwindDao.AddTransactionOrder(); //NorthwindDao.GetTotalIncomeProcedure(2000, 2010, db.Suppliers.First().CompanyName); }
//task 7 public static void TryConcurrentChanges() { var firstCustomerId = GetFirstCustomerId(); NorthwindEntities dbFirst = new NorthwindEntities(); NorthwindEntities dbSecond = new NorthwindEntities(); using (dbFirst) { using (dbSecond) { var customer = dbFirst.Customers.First(x => x.CustomerID == firstCustomerId); if (customer != null) { customer.CompanyName = "edited db"; } var secondCustomer = dbFirst.Customers.First(x => x.CustomerID == firstCustomerId); if (customer != null) { customer.CompanyName = "edited db2"; } dbFirst.SaveChanges(); dbSecond.SaveChanges(); } } }