public void Initialize()
{
_dbContext = new EntityContext();
_validator= new CustomerValidator();
//AlwaysRecreateDatabase
//CreateDatabaseOnlyIfNotExists
//RecreateDatabaseIfModelChanges
Database.SetInitializer(new CreateDatabaseIfNotExists<EntityContext>());
}
protected void btnDatabindOutsideOfContext_Click(object sender, EventArgs e)
{
IEnumerable<Customer> customers;
using (var context = new EntityContext())
{
customers = context.Customers;//.Where(o=>o.FirstName.Contains("a"));
}
//Note intentional error
customersView.DataSource = customers.ToArray();
customersView.DataBind();
}
protected void btnDataBindInContext_Click(object sender, EventArgs e)
{
using (var context = new EntityContext())
{
//dont
//customersView.DataSource = from o in context.Customers select o;
//do:
customersView.DataSource = context.Customers.ToArray();
customersView.DataBind();
}
}
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 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 TestEnumerableOutsideContext()
{
IEnumerable<Customer> customers;
using (EntityContext context = new EntityContext())
{
var repository = new CustomerRepository(context);
customers = repository.GetAllEnumerable();
}
//note the The operation cannot be completed because the DbContext has been disposed.
Debug.WriteLine(string.Format("Customer count:{0}", customers.Count()));
}
public void TestEagerLoading()
{
using (EntityContext context = new EntityContext())
{
var repository = new OrderRepository(context);
var orders = repository.GetAll();
Debug.WriteLine(string.Format("Order count:{0}", orders.Count()));
var firstOrder = orders.First();
//firstOr
//context.SaveChanges();
}
}
public void TestAddCustomerMissingRequiredFields()
{
using (EntityContext context = new EntityContext())
{
Customer customer = new Customer(_validator);
ICustomerRepository repository = new CustomerRepository(context);
repository.Create(customer);
repository.Save();
}
}
//For next stage of unit of work implementation using IContext
//public UnitOfWork(IContext context)
//{
// _context = context;
//}
public UnitOfWork(EntityContext context)
{
_context = context;
}
