public void DbPropertyValues_ToObject_for_an_entity_works_under_partial_trust()
{
using (var context = new AdvancedPatternsMasterContext())
{
var building = context.Buildings.Single(b => b.Name == "Building One");
var buildingClone = (Building)context.Entry(building).CurrentValues.ToObject();
Assert.Equal("Building One", buildingClone.Name);
}
}
public void DbPropertyValues_ToObject_for_a_complex_type_works_under_partial_trust()
{
using (var context = new AdvancedPatternsMasterContext())
{
var building = context.Buildings.Single(b => b.Name == "Building One");
var addressClone =
(Address)context.Entry(building).CurrentValues.GetValue<DbPropertyValues>("Address").ToObject();
Assert.Equal("Redmond", addressClone.City);
}
}
private void AnonymousType_join_selecting_one_member()
{
using (var context = new AdvancedPatternsMasterContext())
{
var query = context.WorkOrders.Select(wo => wo.EmployeeId)
.Join(
context.Employees.Select(e => e.EmployeeId), a => a, b => b, (a, b) => new
{
a
});
var sql = query.ToString();
Assert.True(sql != null);
}
}
private void GroupBy_aggregate_pushdown_single_key()
{
using (var context = new AdvancedPatternsMasterContext())
{
var groupByQuery = from workOrder in context.WorkOrders
group new
{
workOrder.WorkOrderId,
workOrder.Details
} by workOrder.EmployeeId
into ordersByEmployeeGroup
select new
{
EmployeeId = ordersByEmployeeGroup.Key,
OrderCount = ordersByEmployeeGroup.Count(),
MaxOrderId = ordersByEmployeeGroup.Max(o => o.WorkOrderId)
};
var sql = groupByQuery.ToString();
Assert.True(sql != null && sql.ToUpper().Contains("GROUP BY"));
}
}
public void Can_create_non_generic_DbSet_for_abstract_base_type()
{
using (var context = new AdvancedPatternsMasterContext())
{
var set = context.Set(typeof(Employee));
Assert.Equal(typeof(Employee), set.ElementType);
var entity = set.Cast<Employee>().FirstOrDefault();
Assert.IsAssignableFrom<Employee>(entity);
}
}
public void Setting_IsModified_to_false_for_a_modified_complex_property_rejects_changes_to_that_property()
{
using (var context = new AdvancedPatternsMasterContext())
{
var building = context.Buildings.Single(b => b.Name == "Building One");
var entry = context.Entry(building);
entry.ComplexProperty(b => b.Address).CurrentValue = CreateNewAddress();
Assert.True(entry.Property(b => b.Address).IsModified);
entry.ComplexProperty(b => b.Address).IsModified = false;
ValidateBuildingAndNameNotModified(context, building);
}
}
public void IsModified_can_be_set_to_false_when_it_is_currently_false()
{
using (var context = new AdvancedPatternsMasterContext())
{
var building = context.Buildings.Single(b => b.Name == "Building One");
var entry = context.Entry(building);
entry.Property(b => b.Name).IsModified = false;
entry.ComplexProperty(b => b.Address).IsModified = false;
entry.ComplexProperty(b => b.Address).ComplexProperty(a => a.SiteInfo).Property(i => i.Zone).IsModified
= false;
Assert.False(entry.Property(b => b.Name).IsModified);
Assert.False(entry.ComplexProperty(b => b.Address).IsModified);
Assert.False(
entry.ComplexProperty(b => b.Address).ComplexProperty(a => a.SiteInfo).Property(i => i.Zone).
IsModified);
Assert.Equal(EntityState.Unchanged, entry.State);
var objectContext = GetObjectContext(context);
Assert.Equal(0,
objectContext.ObjectStateManager.GetObjectStateEntry(building).GetModifiedProperties().
Count());
}
}
public void IsModified_can_be_set_to_true_when_it_is_currently_true()
{
using (var context = new AdvancedPatternsMasterContext())
{
var building = context.Buildings.Single(b => b.Name == "Building One");
var entry = context.Entry(building);
entry.Property(b => b.Name).IsModified = true;
entry.ComplexProperty(b => b.Address).IsModified = true;
entry.ComplexProperty(b => b.Address).ComplexProperty(a => a.SiteInfo).Property(i => i.Zone).IsModified
= true;
entry.Property(b => b.Name).IsModified = true;
entry.ComplexProperty(b => b.Address).IsModified = true;
entry.ComplexProperty(b => b.Address).ComplexProperty(a => a.SiteInfo).Property(i => i.Zone).IsModified
= true;
ValidateModifiedProperties(context, building);
}
}
private void TestPropertyValuePositiveForState(Func<DbPropertyEntry<Building, string>, string> getValue,
Action<DbPropertyEntry<Building, string>, string> setValue,
EntityState state)
{
using (var context = new AdvancedPatternsMasterContext())
{
var building = context.Buildings.Single(b => b.Name == "Building One");
var entry = context.Entry(building);
var propEntry = entry.Property(b => b.Name);
entry.State = state;
Assert.Equal("Building One", getValue(propEntry));
setValue(propEntry, "New Building");
Assert.Equal("New Building", getValue(propEntry));
}
}
public void Using_wrong_generic_type_with_nested_complex_string_Property_method_throws()
{
using (var context = new AdvancedPatternsMasterContext())
{
var propertyEntry = GetBuildingEntry(context).ComplexProperty(b => b.Address);
Assert.Throws<ArgumentException>(() => propertyEntry.Property<Building>("SiteInfo")).ValidateMessage(
"DbEntityEntry_WrongGenericForProp", "SiteInfo", "Address", "Building", "SiteInfo");
}
}
Using_base_collection_type_for_navigation_property_derived_from_ICollection_entry_using_Member_throws()
{
using (var context = new AdvancedPatternsMasterContext())
{
var entityEntry = GetBuildingEntry(context);
// MailRooms is typed as IList<MailRoom> so this should never work
Assert.Throws<ArgumentException>(() => entityEntry.Member<List<MailRoom>>("MailRooms")).ValidateMessage(
"DbEntityEntry_WrongGenericForCollectionNavProp", typeof(List<MailRoom>).ToString(), "MailRooms",
typeof(Building).ToString(), typeof(ICollection<MailRoom>).ToString());
}
}
public void IsModified_stays_true_for_properties_of_a_complex_property_until_changes_are_rejected_to_all_properties_even_if_the_instance_has_been_changed()
{
using (var context = new AdvancedPatternsMasterContext())
{
var building = context.Buildings.Single(b => b.Name == "Building One");
var addressEntry = context.Entry(building).ComplexProperty(b => b.Address);
var originalAddress = building.Address;
var newAddress = CloneAddress(originalAddress);
newAddress.SiteInfo = originalAddress.SiteInfo; // Keep same nested complex instance
building.Address = newAddress;
building.Address.City = "Grimsby";
addressEntry = context.Entry(building).ComplexProperty(b => b.Address);
AssertStateOfAddressProperties(addressEntry, "Grimsby", "WA", "Clean", isModified: true);
addressEntry.Property(a => a.City).IsModified = false;
AssertStateOfAddressProperties(addressEntry, "Redmond", "WA", "Clean", isModified: false);
}
}
IsModified_stays_true_for_properties_of_a_complex_property_until_changes_are_rejected_to_all_properties()
{
using (var context = new AdvancedPatternsMasterContext())
{
var building = context.Buildings.Single(b => b.Name == "Building One");
building.Address.City = "Grimsby";
building.Address.State = "UK";
building.Address.SiteInfo.Environment = "Fishy";
var addressEntry = context.Entry(building).ComplexProperty(b => b.Address);
AssertStateOfAddressProperties(addressEntry, "Grimsby", "UK", "Fishy", isModified: true);
addressEntry.Property(a => a.City).IsModified = false;
AssertStateOfAddressProperties(addressEntry, "Redmond", "UK", "Fishy", isModified: true);
addressEntry.Property(a => a.State).IsModified = false;
AssertStateOfAddressProperties(addressEntry, "Redmond", "WA", "Fishy", isModified: true);
addressEntry.ComplexProperty(a => a.SiteInfo).Property(s => s.Environment).IsModified = false;
AssertStateOfAddressProperties(addressEntry, "Redmond", "WA", "Clean", isModified: false);
}
}
public void Setting_IsModified_to_false_for_a_nested_property_of_a_modified_complex_property_marks_the_entity_as_Unchanged_if_no_properties_remain_modified()
{
using (var context = new AdvancedPatternsMasterContext())
{
var building = context.Buildings.Single(b => b.Name == "Building One");
var entry = context.Entry(building);
entry.Property(b => b.Value).CurrentValue = 100.0M;
entry.ComplexProperty(b => b.Address).Property(a => a.City).CurrentValue = "Madrid";
entry.ComplexProperty(b => b.Address).Property(a => a.City).IsModified = false;
Assert.False(entry.ComplexProperty(b => b.Address).Property(a => a.City).IsModified);
Assert.Equal("Redmond", building.Address.City);
Assert.Equal(EntityState.Modified, entry.State); // Value is still modified
entry.ComplexProperty(b => b.Address).Property(a => a.City).CurrentValue = "Madrid";
entry.Property(b => b.Value).IsModified = false;
entry.ComplexProperty(b => b.Address).Property(a => a.City).IsModified = false;
Assert.False(entry.ComplexProperty(b => b.Address).Property(a => a.City).IsModified);
Assert.Equal("Redmond", building.Address.City);
Assert.Equal(EntityState.Unchanged, entry.State); // Nothing is modified
}
}
protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
AdvancedPatternsMasterContext.SetupModel(modelBuilder);
base.OnModelCreating(modelBuilder);
}
public void Using_generic_type_that_is_not_ICollection_to_get_collection_entry_using_Member_throws()
{
using (var context = new AdvancedPatternsMasterContext())
{
var entityEntry = GetBuildingEntry(context);
// MailRooms is typed as IList<MailRoom> so at first glance it looks like this should work
// but it doesn't because the returned type must use ICollection.
Assert.Throws<ArgumentException>(() => entityEntry.Member<IList<MailRoom>>("MailRooms")).ValidateMessage
("DbEntityEntry_WrongGenericForCollectionNavProp", typeof(IList<MailRoom>).ToString(), "MailRooms",
typeof(Building).ToString(), typeof(ICollection<MailRoom>).ToString());
}
}
private void IsPropertyChangedTest(Action<Building, DbEntityEntry<Building>, ObjectStateEntry> test)
{
using (var context = new AdvancedPatternsMasterContext())
{
var building = context.Buildings.Single(b => b.Name == "Building One");
var entry = context.Entry(building);
var stateEntry = GetObjectContext(context).ObjectStateManager.GetObjectStateEntry(building);
test(building, entry, stateEntry);
}
}
public void Using_wrong_generic_type_for_complex_property_with_string_Member_method_throws()
{
using (var context = new AdvancedPatternsMasterContext())
{
var entry = GetBuildingEntry(context);
Assert.Throws<ArgumentException>(() => entry.Member<string>("Address")).ValidateMessage(
"DbEntityEntry_WrongGenericForProp", "Address", "Building", "String", "Address");
}
}
public void IsPropertyChanged_returns_true_for_scalar_property_that_is_changed_and_marked_as_modified()
{
using (var context = new AdvancedPatternsMasterContext())
{
var building = context.Buildings.Single(b => b.Name == "Building One");
var entry = context.Entry(building);
var stateEntry = GetObjectContext(context).ObjectStateManager.GetObjectStateEntry(building);
entry.Property(b => b.Name).CurrentValue = "Oops I Did It Again!";
Assert.True(entry.Property(b => b.Name).IsModified);
Assert.True(stateEntry.IsPropertyChanged("Name"));
building.Name = "Building Two";
context.ChangeTracker.DetectChanges();
building.Name = "Building One";
context.ChangeTracker.DetectChanges();
Assert.True(entry.Property(b => b.Name).IsModified);
Assert.False(stateEntry.IsPropertyChanged("Name"));
}
}
public void Original_value_cannot_be_read_or_set_for_an_object_in_the_Added_state()
{
EntityState state = EntityState.Added;
using (var context = new AdvancedPatternsMasterContext())
{
var building = context.Buildings.Single(b => b.Name == "Building One");
var entry = context.Entry(building);
var propEntry = entry.Property(b => b.Name);
entry.State = state;
Assert.Throws<InvalidOperationException>(() => { var _ = propEntry.OriginalValue; }).ValidateMessage(
"DbPropertyValues_CannotGetValuesForState", "OriginalValues", state.ToString());
Assert.Throws<InvalidOperationException>(() => propEntry.OriginalValue = "").ValidateMessage(
"DbPropertyValues_CannotGetValuesForState", "OriginalValues", state.ToString());
}
}
private void DbPropertyEntryTest(EntityState state, Action<DbEntityEntry<Building>> test)
{
using (var context = new AdvancedPatternsMasterContext())
{
var entry = context.Entry(new Building
{
Name = "Building 18",
Address = new Address
{
Street = "1 Microsoft Way",
City = "Redmond",
State = "WA",
ZipCode = "98052",
County = "KING",
SiteInfo = new SiteInfo { Zone = 2, Environment = "Clean" }
},
NotInModel = "NotInModel",
});
entry.State = state;
test(entry);
}
}
public void IsModified_returns_true_only_for_modified_properties()
{
using (var context = new AdvancedPatternsMasterContext())
{
var building = context.Buildings.Single(b => b.Name == "Building One");
building.Name = "New Building";
building.Address.State = "IA";
ValidateModifiedProperties(context, building);
}
}
private DbEntityEntry<Building> GetBuildingEntry(AdvancedPatternsMasterContext context)
{
var building = new Building();
context.Buildings.Attach(building);
return context.Entry(building);
}
private void ValidateModifiedProperties(AdvancedPatternsMasterContext context, Building building)
{
var entry = context.Entry(building);
Assert.Equal(EntityState.Modified, entry.State);
Assert.True(entry.Property(b => b.Name).IsModified);
Assert.True(entry.ComplexProperty(b => b.Address).IsModified);
Assert.False(entry.Property(b => b.Value).IsModified);
Assert.True(entry.ComplexProperty(b => b.Address).Property(a => a.Street).IsModified);
Assert.True(entry.ComplexProperty(b => b.Address).Property(a => a.City).IsModified);
Assert.True(entry.ComplexProperty(b => b.Address).Property(a => a.State).IsModified);
Assert.True(entry.ComplexProperty(b => b.Address).Property(a => a.ZipCode).IsModified);
Assert.True(entry.ComplexProperty(b => b.Address).ComplexProperty(a => a.SiteInfo).IsModified);
Assert.True(
entry.ComplexProperty(b => b.Address).ComplexProperty(a => a.SiteInfo).Property(i => i.Environment).
IsModified);
Assert.True(
entry.ComplexProperty(b => b.Address).ComplexProperty(a => a.SiteInfo).Property(i => i.Zone).IsModified);
var objectContext = GetObjectContext(context);
var modified = objectContext.ObjectStateManager.GetObjectStateEntry(building).GetModifiedProperties();
Assert.Equal(2, modified.Count());
Assert.True(modified.Contains("Name"));
Assert.True(modified.Contains("Address"));
}
public void Using_Collection_for_a_complex_prop_throws()
{
using (var context = new AdvancedPatternsMasterContext())
{
var entry = GetBuildingEntry(context);
Assert.Throws<ArgumentException>(() => entry.Collection("Address")).ValidateMessage(
"DbEntityEntry_NotANavigationProperty", "Address", "Building");
}
}
private void ValidateBuildingAndNameNotModified(AdvancedPatternsMasterContext context, Building building)
{
var entry = context.Entry(building);
Assert.False(entry.Property(b => b.Name).IsModified);
Assert.False(entry.ComplexProperty(b => b.Address).IsModified);
Assert.False(entry.ComplexProperty(b => b.Address).Property(a => a.Street).IsModified);
Assert.False(entry.ComplexProperty(b => b.Address).Property(a => a.City).IsModified);
Assert.False(entry.ComplexProperty(b => b.Address).Property(a => a.State).IsModified);
Assert.False(entry.ComplexProperty(b => b.Address).Property(a => a.ZipCode).IsModified);
Assert.False(entry.ComplexProperty(b => b.Address).ComplexProperty(a => a.SiteInfo).IsModified);
Assert.False(
entry.ComplexProperty(b => b.Address).ComplexProperty(a => a.SiteInfo).Property(i => i.Environment).
IsModified);
Assert.False(
entry.ComplexProperty(b => b.Address).ComplexProperty(a => a.SiteInfo).Property(i => i.Zone).IsModified);
Assert.Equal("Building One", entry.Property(b => b.Name).CurrentValue);
Assert.Equal("100 Work St", entry.ComplexProperty(b => b.Address).Property(a => a.Street).CurrentValue);
Assert.Equal("Redmond", entry.ComplexProperty(b => b.Address).Property(a => a.City).CurrentValue);
Assert.Equal("WA", entry.ComplexProperty(b => b.Address).Property(a => a.State).CurrentValue);
Assert.Equal("98052", entry.ComplexProperty(b => b.Address).Property(a => a.ZipCode).CurrentValue);
Assert.Equal("Clean",
entry.ComplexProperty(b => b.Address).ComplexProperty(a => a.SiteInfo).Property(
i => i.Environment).CurrentValue);
Assert.Equal(1,
entry.ComplexProperty(b => b.Address).ComplexProperty(a => a.SiteInfo).Property(i => i.Zone).
CurrentValue);
var objectContext = GetObjectContext(context);
var modified = objectContext.ObjectStateManager.GetObjectStateEntry(building).GetModifiedProperties();
Assert.False(modified.Contains("Name"));
Assert.False(modified.Contains("Address"));
}
public void Can_get_generic_complex_entry_using_Member()
{
using (var context = new AdvancedPatternsMasterContext())
{
var entityEntry = GetBuildingEntry(context);
var propEntry = entityEntry.Member<Address>("Address");
Assert.IsType<DbComplexPropertyEntry<Building, Address>>(propEntry);
Assert.Same(entityEntry.Entity.Address, propEntry.CurrentValue);
}
}
public void Can_create_DbSet_for_abstract_base_type()
{
using (var context = new AdvancedPatternsMasterContext())
{
var set = context.Set<Employee>();
Assert.IsType<DbSet<Employee>>(set);
var entity = set.FirstOrDefault();
Assert.IsAssignableFrom<Employee>(entity);
}
}
public void Can_get_non_complex_entry_using_Member()
{
using (var context = new AdvancedPatternsMasterContext())
{
var entityEntry = (DbEntityEntry)GetBuildingEntry(context);
var propEntry = entityEntry.Member("Address");
Assert.IsType<DbComplexPropertyEntry>(propEntry);
Assert.Same(((Building)entityEntry.Entity).Address, propEntry.CurrentValue);
}
}
private void SaveChanges_bubbles_presave_exception_implementation(Func<DbContext, int> saveChanges)
{
EnsureDatabaseInitialized(() => new AdvancedPatternsMasterContext());
using (new TransactionScope())
{
using (var context = new AdvancedPatternsMasterContext())
{
var emp = new CurrentEmployee { EmployeeId = 4 };
var ord = new WorkOrder { WorkOrderId = 2, EmployeeId = 4 };
context.Employees.Attach(emp);
context.WorkOrders.Attach(ord);
// Create a conceptual null
GetObjectContext(context).ObjectStateManager.ChangeObjectState(emp, EntityState.Deleted);
Assert.Throws<InvalidOperationException>(() => context.SaveChanges()).ValidateMessage(
"ObjectContext_CommitWithConceptualNull");
}
}
}
public void Can_get_generic_collection_for_navigation_property_derived_from_ICollection_entry_using_Member()
{
using (var context = new AdvancedPatternsMasterContext())
{
var entityEntry = GetBuildingEntry(context);
var propEntry = entityEntry.Member<ICollection<MailRoom>>("MailRooms");
Assert.IsType<DbCollectionEntry<Building, MailRoom>>(propEntry);
Assert.Same(entityEntry.Entity.MailRooms, propEntry.CurrentValue);
}
}