public void Read_and_write_using_AdvancedPatternsModelFirst_created_from_T4_template()
{
var building18 = CreateBuilding();
using (new TransactionScope())
{
using (var context = new AdvancedPatternsModelFirstContext())
{
context.Buildings.Add(building18);
var foundBuilding = context.Buildings.Find(new Guid(Building18Id));
Assert.Equal("Building 18", foundBuilding.Name);
context.SaveChanges();
}
using (var context = new AdvancedPatternsModelFirstContext())
{
var foundBuilding = context.Buildings.Find(new Guid(Building18Id));
Assert.Equal("Building 18", foundBuilding.Name);
Assert.Equal(3, context.Entry(foundBuilding).Collection(b => b.Offices).Query().Count());
var arthursOffice = context.Offices.Single(o => o.Number == "1/1125");
Assert.Same(foundBuilding, arthursOffice.GetBuilding());
}
}
}
public void Executing_a_stored_proc_mapped_to_a_function_import_with_merge_option_preserve_changes()
{
using (var context = new AdvancedPatternsModelFirstContext())
{
// Arrange
var office1 = context.Offices.Find("1/1221", AdvancedPatternsModelFirstInitializer.KnownBuildingGuid);
var office2 = context.Offices.Find("1/1223", AdvancedPatternsModelFirstInitializer.KnownBuildingGuid);
context.Entry(office2).Property("Description").CurrentValue = "Test";
// Act
var offices = context.AllOfficesStoredProc(MergeOption.PreserveChanges).ToList();
// Verify
Assert.True(context.Entry(office1).State == EntityState.Unchanged);
Assert.True(context.Entry(office2).State == EntityState.Modified);
Assert.True(context.ChangeTracker.Entries<OfficeMf>().Count() == 4);
}
}