public void AddCustomerTest()
{
using(var dataContext = new ModelDataContext())
using (var unitOfWork = new UnitOfWork(dataContext) )
{
var customerID = Guid.NewGuid();
var customer = new Customer()
{
ID = Guid.NewGuid(),
Name = "BBC",
Address = "No.1 Bee Street",
City = "London",
Country = "UK",
Region = "AA",
Fax = "000000",
Phone = "00000000000",
PostalCode = "555555"
};
var customerRepository = unitOfWork.Repository<Customer>();
customerRepository.Insert(customer); ;
unitOfWork.SaveChanges();
var insertedCustomer = customerRepository.Find(customerID);
Assert.IsNotNull(insertedCustomer);
Assert.AreEqual(customerID, insertedCustomer.ID);
}
}
public void GetCustomerTest()
{
using (var dataContext = new ModelDataContext())
using (var unitOfWork = new UnitOfWork(dataContext))
{
var customerID = Guid.Parse("46de4e9f-564f-4273-bbd1-45bed3166668");
var customerRepository = unitOfWork.Repository<Customer>();
var insertedCustomer = customerRepository.Find(customerID);
Assert.IsNotNull(insertedCustomer);
Assert.AreEqual(customerID, insertedCustomer.ID);
}
}
public void QueryByRegionAndCityTest()
{
var customerRegion = "AA";
var customerCity = "London";
using (var dataContext = new ModelDataContext())
using (var unitOfWork = new UnitOfWork(dataContext))
{
var customerRepository = unitOfWork.Repository<Customer>();
var customers = customerRepository.SelectByRegionAndCity(customerRegion, customerCity);
Assert.AreEqual(3, customers.ToList().Count);
}
}
public void QueryCustomersByRegionTest()
{
using (var dataContext = new ModelDataContext())
using (var unitOfWork = new UnitOfWork(dataContext))
{
var customerRegion = "AA";
var customerRepository = unitOfWork.Repository<Customer>();
var customers = customerRepository.SelectByRegion(customerRegion);
Assert.AreEqual(3, customers.Count());
}
}