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