public void ConcurrencyTests()
{
//Get the same record but loaded from two separate contexts so the tracking won't overlap.
ICustomerRepository repository = new CustomerRepository(_dbContext);
var secondContext = new EntityContext();
//add new customer to db.
var newCustomer = CreateCustomer(repository);
//load this customer from context 1
var firstCustomer1 = repository.GetById(newCustomer.CustomerId);
firstCustomer1.City = "newCity3";
//load the same customer from context 2
ICustomerRepository secondRepository = new CustomerRepository(secondContext);
var firstCustomer2 = secondRepository.GetById(firstCustomer1.CustomerId);
//Check the states
Debug.WriteLine(_dbContext.Entry(newCustomer).State);
Debug.WriteLine(_dbContext.Entry(firstCustomer1).State);
Debug.WriteLine(secondContext.Entry(firstCustomer2).State);
//Modify the second customer. We have the same TimeStamp as the original record
//however the timestamp in the database would've been updated already.
firstCustomer2.Address = "222 main st" + DateTime.Now.ToString();
Debug.WriteLine(secondContext.Entry(firstCustomer2).State);
//This should update that customer.
repository.Update(firstCustomer1);
repository.Save();
//This should throw an exception.
secondRepository.Update(firstCustomer2);
secondRepository.Save();
secondContext.Dispose();
}
public void InsertAndLoadCustomer()
{
//Add to context just to show its state prior to save
Customer customerNew = new Customer(_validator);
customerNew.FirstName = "Mary";
customerNew.LastName = "Doe";
_dbContext.Customers.Attach(customerNew);
//State is 'unchanged' no errors raised by simply adding it.
Debug.WriteLine(_dbContext.Entry(customerNew).State);
//Insert via repository
ICustomerRepository repository = new CustomerRepository(_dbContext);
//creates and saves it
var customer = CreateCustomer(repository);
//Get its state from the context - should be unchanged (as its saved)
Debug.WriteLine(_dbContext.Entry(customer).State);
//Saving again does nothing to the database (see profiler)
repository.Update(customer);
repository.Save();
//update the first name.
customer.FirstName = "John";
//Get its state from the context
Debug.WriteLine(_dbContext.Entry(customer).State);
//saving again notice only the first name is updated.
repository.Update(customer);
repository.Save();
Customer insertCustomer = new Customer(_validator);
insertCustomer.FirstName = "Jane";
insertCustomer.LastName = "Doe";
insertCustomer.Address = "555 main st";
insertCustomer.City = "Orlando";
insertCustomer.Zip = "33400";
insertCustomer.State = "FL";
Debug.WriteLine(insertCustomer.CustomerId);
_dbContext.Customers.Add(insertCustomer);
Debug.WriteLine(_dbContext.Entry(insertCustomer).State);
_dbContext.SaveChanges();
//Note the primary key is automatically updated.
Debug.WriteLine(insertCustomer.CustomerId);
Debug.WriteLine(_dbContext.Entry(insertCustomer).State);
}
public void ShowSmartFieldUpating()
{
ICustomerRepository repository = new CustomerRepository(_dbContext);
var customers = repository.GetAll();
Debug.Assert(customers.Count() == 0);
Customer customer = new Customer(_validator) { FirstName = "Test", City = "bethlehem" };
repository.Create(customer);
repository.Save();
customer.Address = "1 main st" + DateTime.Now.ToString();
customer.City = customer.City;
repository.Update(customer);
repository.Save();
}
public void TestNoKey()
{
ICustomerRepository repository = new CustomerRepository(_dbContext);
var bip = new Customer(_validator);
bip.CustomerId = 10;
bip.CustomerId = 20;
var customer = CreateCustomer(repository);
_dbContext.Customers.Attach(bip);
bip.CustomerId = 30;
Debug.WriteLine(_dbContext.Entry(bip).State);
var newContext = new EntityContext();
var repository2 = new CustomerRepository(newContext);
Debug.WriteLine(newContext.Entry(customer).State);
customer.Address = "555";
Debug.WriteLine(newContext.Entry(customer).State);
//newContext.Entry(customer).State = System.Data.EntityState.Modified;
Debug.WriteLine(newContext.Entry(customer).State);
newContext.Customers.Attach(customer);
customer.CustomerId = 0;
newContext.SaveChanges();
repository2.Update(customer);
repository2.Save();
customer.Address = "556";
Debug.WriteLine(newContext.Entry(customer).State);
}
public void InsertAndUpdateCustomer()
{
ICustomerRepository repository = new CustomerRepository(_dbContext);
var customer = CreateCustomer(repository);
Debug.WriteLine(_dbContext.Entry(customer).State);
customer.City = "City " + DateTime.Now.ToString();
Debug.WriteLine(_dbContext.Entry(customer).State);
repository.Update(customer);
repository.Save();
Debug.WriteLine(_dbContext.Entry(customer).State);
}
