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);
}
}
public void Can_read_entities_from_a_stored_proc_mapped_to_a_function_import_with_merge_option()
{
using (var context = new AdvancedPatternsModelFirstContext())
{
var offices = context.AllOfficesStoredProc(MergeOption.NoTracking).ToList();
Assert.Equal(4, offices.Count);
Assert.Equal(0, context.Offices.Local.Count);
new List<string>
{
"1/1221",
"1/1223",
"2/1458",
"2/1789"
}.ForEach(
n => offices.Where(o => o.Number == n).Single());
}
}
public void Executing_a_stored_proc_mapped_to_a_function_import_honors_no_tracking_merge_option()
{
using (var context = new AdvancedPatternsModelFirstContext())
{
// Act
var offices = context.AllOfficesStoredProc(MergeOption.NoTracking).ToList();
// Verify
Assert.True(context.ChangeTracker.Entries<OfficeMf>().Count() == 0);
}
}
public void Can_read_entities_from_a_stored_proc_mapped_to_a_function_import()
{
using (var context = new AdvancedPatternsModelFirstContext())
{
var offices = context.AllOfficesStoredProc().ToList();
Assert.Equal(4, offices.Count);
Assert.Equal(4, context.Offices.Local.Count);
var officeNumbers = new List<string>
{
"1/1221", "1/1223", "2/1458", "2/1789"
};
foreach (var officeNumber in officeNumbers)
{
offices.Single(o => o.Number == officeNumber);
}
}
}
