private void InsertNewCustomer(EFCustomer customer)
{
using (var custRepo = new CustomerRepository())
{
custRepo.Insert(customer);
custRepo.RepoContext.Commit();
}
}
public void ef_update_by_manual_compare_test()
{
var customer = GetCustomerInfo();
InsertNewCustomer(customer);
var cInfo = new EFCustomer();
using (var repo = new CustomerRepository())
{
cInfo = repo.GetCustomFullInfo(1);
}
cInfo.Email = "*****@*****.**";
cInfo.Address.City = "SZ";
cInfo.Address.Zip = "000000000";
cInfo.ObjectState = ObjectStateType.Modified;
cInfo.EFNote.First().NoteText = "DDDD";
cInfo.EFNote.First().ObjectState = ObjectStateType.Modified;
cInfo.EFNote.Last().ObjectState = ObjectStateType.Deleted;
var newNote = new EFNote
{
CustomerId = 1,
NoteText = "CCCC",
ObjectState = ObjectStateType.Added
};
cInfo.EFNote.Add(newNote);
using (var repo = new CustomerRepository())
{
repo.Update(cInfo);
repo.RepoContext.Commit();
}
using (var repo = new CustomerRepository())
{
cInfo = repo.GetCustomFullInfo(1);
}
cInfo.Email.Should().Be("*****@*****.**");
var address = cInfo.Address;
address.City.Should().Be("SZ");
address.Zip.Should().Be("000000000");
cInfo.EFNote.Count.Should().Be(2);
cInfo.EFNote.Last().NoteText.Should().Be("CCCC");
cInfo.EFNote.First().NoteText.Should().Be("DDDD");
}
private EFCustomer GetCustomerInfo()
{
var customer = new EFCustomer
{
Address = new EFAddress("China", "SH", "SH", "A street", "12345"),
UserName = "******",
Phone = "111111",
Password = "******",
EFNote = new List <EFNote> {
new EFNote {
NoteText = "AA"
}, new EFNote {
NoteText = "BB"
}
}
};
return(customer);
}
public void ef_update_by_partial_test()
{
var customer = GetCustomerInfo();
InsertNewCustomer(customer);
var cInfo = new EFCustomer();
using (var repo = new CustomerRepository())
{
cInfo = repo.GetCustomFullInfo(1);
}
cInfo.SetUpdate(() => cInfo.Address.City, "SZ");
cInfo.SetUpdate(() => cInfo.Address.Zip, "000000000");
cInfo.SetUpdate(() => cInfo.Email, "*****@*****.**");
var firstNote = cInfo.EFNote.First();
firstNote.SetUpdate(() => firstNote.NoteText, "DDDD");
using (var repo = new CustomerRepository())
{
repo.Update(cInfo);
repo.RepoContext.Commit();
}
using (var repo = new CustomerRepository())
{
cInfo = repo.GetCustomFullInfo(1);
}
cInfo.Email.Should().Be("*****@*****.**");
var address = cInfo.Address;
address.City.Should().Be("SZ");
address.Zip.Should().Be("000000000");
cInfo.EFNote.Count.Should().Be(2);
cInfo.EFNote.Last().NoteText.Should().Be("BB");
cInfo.EFNote.First().NoteText.Should().Be("DDDD");
}