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); } }