public void Query_principal_include_dependent_unidirectional_with_existing(EntityState existingState)
{
Seed();
using (var context = new QueryFixupContext())
{
var newDependent = new ProductPN {
CategoryId = 77
};
context.Entry(newDependent).State = existingState;
var principal = context.Set <CategoryPN>().Include(e => e.Products).Single();
var dependent = principal.Products.Single(e => e.Id != newDependent.Id);
AssertFixup(
context,
() =>
{
Assert.Equal(principal.Id, dependent.CategoryId);
Assert.Contains(dependent, principal.Products);
Assert.Equal(principal.Id, newDependent.CategoryId);
Assert.Contains(newDependent, principal.Products);
});
}
}
public void Query_dependent_include_principal_self_ref_unidirectional_with_existing(EntityState existingState)
{
Seed();
using (var context = new QueryFixupContext())
{
var newDependent = new WidgetDN {
ParentWidgetId = 77
};
context.Entry(newDependent).State = existingState;
var widgets = context.Set <WidgetDN>().Include(e => e.ParentWidget).ToList();
var dependent = widgets.Single(e => e.Id == 78);
var principal = widgets.Single(e => e.Id == 77);
AssertFixup(
context,
() =>
{
Assert.Equal(principal.Id, dependent.ParentWidgetId);
Assert.Same(principal, dependent.ParentWidget);
Assert.Equal(principal.Id, newDependent.ParentWidgetId);
Assert.Same(principal, newDependent.ParentWidget);
});
}
}
public void Query_self_ref_prinipal_nav_only_with_existing(EntityState existingState)
{
Seed();
using (var context = new QueryFixupContext())
{
var newDependent = new WidgetPN {
ParentWidgetId = 77
};
context.Entry(newDependent).State = existingState;
var widgets = context.Set <WidgetPN>().ToList();
var dependent = widgets.Single(e => e.Id == 78);
var principal = widgets.Single(e => e.Id == 77);
AssertFixup(
context,
() =>
{
Assert.Equal(principal.Id, dependent.ParentWidgetId);
Assert.Contains(dependent, principal.ChildWidgets);
Assert.Equal(principal.Id, newDependent.ParentWidgetId);
Assert.Contains(newDependent, principal.ChildWidgets);
});
}
}
public void Query_dependent_include_principal_unidirectional_with_existing(EntityState existingState)
{
Seed();
using (var context = new QueryFixupContext())
{
var newDependent = new ProductDN {
CategoryId = 77
};
context.Entry(newDependent).State = existingState;
var dependent = context.Set <ProductDN>().Include(e => e.Category).Single();
var principal = dependent.Category;
AssertFixup(
context,
() =>
{
Assert.Equal(principal.Id, dependent.CategoryId);
Assert.Same(principal, dependent.Category);
Assert.Equal(principal.Id, newDependent.CategoryId);
Assert.Same(principal, newDependent.Category);
});
}
}
public void Query_owned()
{
Seed();
using var context = new QueryFixupContext();
var owned = context.Set <Order>().Single().OrderDetails;
var principal = context.Set <Order>().AsNoTracking().Single();
AssertFixup(
context,
() =>
{
var dependentEntry = context.Entry(owned);
Assert.Equal(principal.Id, dependentEntry.Property("OrderId").CurrentValue);
Assert.Equal(nameof(Order.OrderDetails), dependentEntry.Metadata.FindOwnership().PrincipalToDependent.Name);
});
}
public void Query_subowned_foreign_key()
{
Seed();
using (var context = new QueryFixupContext())
{
var foreignKeyValue = context.Set <Order>()
.Select(o => EF.Property <int?>(o.OrderDetails.BillingAddress, "OrderDetailsId")).Single();
var principal = context.Set <Order>().AsNoTracking().Single();
AssertFixup(
context,
() =>
{
Assert.Equal(principal.Id, foreignKeyValue);
});
}
}
public void Query_owned()
{
Seed();
using (var context = new QueryFixupContext())
{
var owned = context.Set <Order>().Select(o => o.OrderDetails).Single();
var principal = context.Set <Order>().AsNoTracking().Single();
AssertFixup(
context,
() =>
{
var dependentEntry = context.Entry(owned);
Assert.Equal(principal.Id, dependentEntry.Property("OrderId").CurrentValue);
Assert.Equal(nameof(Order.OrderDetails), dependentEntry.Metadata.DefiningNavigationName);
});
}
}
public void Query_ownership_navigations()
{
Seed();
using var context = new QueryFixupContext();
var principal = context.Set <Order>()
.Single();
AssertFixup(
context,
() =>
{
var dependent = principal.OrderDetails;
Assert.Same(principal, dependent.Order);
var subDependent1 = dependent.BillingAddress;
var subDependent2 = dependent.ShippingAddress;
Assert.Same(dependent, subDependent1.OrderDetails);
Assert.Same(dependent, subDependent2.OrderDetails);
Assert.Equal("BillMe", subDependent1.Street);
Assert.Equal("ShipMe", subDependent2.Street);
Assert.Equal(4, context.ChangeTracker.Entries().Count());
var principalEntry = context.Entry(principal);
Assert.Equal(EntityState.Unchanged, principalEntry.State);
var dependentEntry = principalEntry.Reference(p => p.OrderDetails).TargetEntry;
Assert.Equal(principal.Id, dependentEntry.Property("OrderId").CurrentValue);
Assert.Equal(EntityState.Unchanged, dependentEntry.State);
Assert.Equal(nameof(OrderDetails), dependentEntry.Metadata.FindOwnership().PrincipalToDependent.Name);
var subDependent1Entry = dependentEntry.Reference(p => p.BillingAddress).TargetEntry;
Assert.Equal(principal.Id, subDependent1Entry.Property("OrderDetailsId").CurrentValue);
Assert.Equal(EntityState.Unchanged, subDependent1Entry.State);
Assert.Equal(
typeof(OrderDetails).DisplayName()
+ "."
+ nameof(OrderDetails.BillingAddress)
+ "#"
+ typeof(Address).ShortDisplayName(), subDependent1Entry.Metadata.Name);
var subDependent2Entry = dependentEntry.Reference(p => p.ShippingAddress).TargetEntry;
Assert.Equal(principal.Id, subDependent2Entry.Property("OrderDetailsId").CurrentValue);
Assert.Equal(EntityState.Unchanged, subDependent2Entry.State);
Assert.Equal(
typeof(OrderDetails).DisplayName()
+ "."
+ nameof(OrderDetails.ShippingAddress)
+ "#"
+ typeof(Address).ShortDisplayName(), subDependent2Entry.Metadata.Name);
});
}
public void Query_ownership_navigations()
{
Seed();
using (var context = new QueryFixupContext())
{
// TODO: Infer these includes
// Issue #2953
var principal = context.Set <Order>()
.Include(o => o.OrderDetails.BillingAddress)
.Include(o => o.OrderDetails.ShippingAddress)
.Single();
AssertFixup(
context,
() =>
{
var dependent = principal.OrderDetails;
Assert.Same(principal, dependent.Order);
var subDependent1 = dependent.BillingAddress;
var subDependent2 = dependent.ShippingAddress;
Assert.Same(dependent, subDependent1.OrderDetails);
Assert.Same(dependent, subDependent2.OrderDetails);
Assert.Equal("BillMe", subDependent1.Street);
Assert.Equal("ShipMe", subDependent2.Street);
Assert.Equal(4, context.ChangeTracker.Entries().Count());
var principalEntry = context.Entry(principal);
Assert.Equal(EntityState.Unchanged, principalEntry.State);
var dependentEntry = principalEntry.Reference(p => p.OrderDetails).TargetEntry;
Assert.Equal(principal.Id, dependentEntry.Property("OrderId").CurrentValue);
Assert.Equal(EntityState.Unchanged, dependentEntry.State);
Assert.Equal(nameof(Order.OrderDetails), dependentEntry.Metadata.DefiningNavigationName);
var subDependent1Entry = dependentEntry.Reference(p => p.BillingAddress).TargetEntry;
Assert.Equal(principal.Id, subDependent1Entry.Property("OrderDetailsId").CurrentValue);
Assert.Equal(EntityState.Unchanged, subDependent1Entry.State);
Assert.Equal(nameof(OrderDetails.BillingAddress), subDependent1Entry.Metadata.DefiningNavigationName);
var subDependent2Entry = dependentEntry.Reference(p => p.ShippingAddress).TargetEntry;
Assert.Equal(principal.Id, subDependent2Entry.Property("OrderDetailsId").CurrentValue);
Assert.Equal(EntityState.Unchanged, subDependent2Entry.State);
Assert.Equal(nameof(OrderDetails.ShippingAddress), subDependent2Entry.Metadata.DefiningNavigationName);
});
}
}
public void Query_principal_include_dependent_unidirectional()
{
Seed();
using var context = new QueryFixupContext();
var principal = context.Set <CategoryPN>().Include(e => e.Products).Single();
var dependent = principal.Products.Single();
AssertFixup(
context,
() =>
{
Assert.Equal(principal.Id, dependent.CategoryId);
Assert.Equal(new[] { dependent }.ToList(), principal.Products);
});
}
public void Query_dependent_include_principal_unidirectional()
{
Seed();
using var context = new QueryFixupContext();
var dependent = context.Set <ProductDN>().Include(e => e.Category).Single();
var principal = dependent.Category;
AssertFixup(
context,
() =>
{
Assert.Equal(principal.Id, dependent.CategoryId);
Assert.Same(principal, dependent.Category);
});
}
public void Query_principal_include_dependent_unidirectional_one_to_one()
{
Seed();
using var context = new QueryFixupContext();
var principal = context.Set <ParentPN>().Include(e => e.Child).Single();
var dependent = principal.Child;
AssertFixup(
context,
() =>
{
Assert.Equal(principal.Id, dependent.ParentId);
Assert.Same(dependent, principal.Child);
});
}
public void Query_dependent_include_principal_one_to_one()
{
Seed();
using var context = new QueryFixupContext();
var dependent = context.Set <Child>().Include(e => e.Parent).Single();
var principal = dependent.Parent;
AssertFixup(
context,
() =>
{
Assert.Equal(principal.Id, dependent.ParentId);
Assert.Same(principal, dependent.Parent);
Assert.Same(dependent, principal.Child);
});
}
public void Query_principal_include_dependent_self_ref_unidirectional()
{
Seed();
using var context = new QueryFixupContext();
var widgets = context.Set <WidgetPN>().Include(e => e.ChildWidgets).ToList();
var dependent = widgets.Single(e => e.Id == 78);
var principal = widgets.Single(e => e.Id == 77);
AssertFixup(
context,
() =>
{
Assert.Equal(principal.Id, dependent.ParentWidgetId);
Assert.Equal(new[] { dependent }.ToList(), principal.ChildWidgets);
});
}
public void Query_self_ref_one_to_one_dependent_nav_only()
{
Seed();
using var context = new QueryFixupContext();
var smidgets = context.Set <SmidgetDN>().ToList();
var dependent = smidgets.Single(e => e.Id == 78);
var principal = smidgets.Single(e => e.Id == 77);
AssertFixup(
context,
() =>
{
Assert.Equal(principal.Id, dependent.ParentSmidgetId);
Assert.Same(principal, dependent.ParentSmidget);
});
}
public void Query_principal_include_dependent_self_ref_one_to_one_unidirectional()
{
Seed();
using var context = new QueryFixupContext();
var smidgets = context.Set <SmidgetPN>().Include(e => e.ChildSmidget).ToList();
var dependent = smidgets.Single(e => e.Id == 78);
var principal = smidgets.Single(e => e.Id == 77);
AssertFixup(
context,
() =>
{
Assert.Equal(principal.Id, dependent.ParentSmidgetId);
Assert.Same(dependent, principal.ChildSmidget);
});
}
public void Query_principal_include_dependent_unidirectional()
{
Seed();
using (var context = new QueryFixupContext())
{
var principal = context.Set<CategoryPN>().Include(e => e.Products).Single();
var dependent = principal.Products.Single();
AssertFixup(
context,
() =>
{
Assert.Equal(principal.Id, dependent.CategoryId);
Assert.Equal(new[] { dependent }.ToList(), principal.Products);
});
}
}
public void Query_self_ref()
{
Seed();
using var context = new QueryFixupContext();
var widgets = context.Set <Widget>().ToList();
var dependent = widgets.Single(e => e.Id == 78);
var principal = widgets.Single(e => e.Id == 77);
AssertFixup(
context,
() =>
{
Assert.Equal(principal.Id, dependent.ParentWidgetId);
Assert.Same(principal, dependent.ParentWidget);
Assert.Equal(new[] { dependent }.ToList(), principal.ChildWidgets);
});
}
public void Query_dependent_include_principal_unidirectional()
{
Seed();
using (var context = new QueryFixupContext())
{
var dependent = context.Set<ProductDN>().Include(e => e.Category).Single();
var principal = dependent.Category;
AssertFixup(
context,
() =>
{
Assert.Equal(principal.Id, dependent.CategoryId);
Assert.Same(principal, dependent.Category);
});
}
}
public void Query_subowned()
{
Seed();
using var context = new QueryFixupContext();
// Owned entity without owner. Issue #24807.
Assert.Equal(
CoreStrings.OwnedEntitiesCannotBeTrackedWithoutTheirOwner,
Assert.Throws <InvalidOperationException>(
() =>
{
var subDependent1 = context.Set <Order>()
.Include(a => a.OrderDetails.BillingAddress.OrderDetails.Order)
.Select(o => o.OrderDetails.BillingAddress)
.Single();
}).Message);
// var subDependent2 = context.Set<Order>()
// .Include(a => a.OrderDetails.ShippingAddress.OrderDetails.Order)
// .Select(o => o.OrderDetails.ShippingAddress)
// .Single();
//
// AssertFixup(
// context,
// () =>
// {
// Assert.Equal("BillMe", subDependent1.Street);
// Assert.Equal("ShipMe", subDependent2.Street);
//
// var dependent = subDependent1.OrderDetails;
// Assert.Same(dependent, subDependent2.OrderDetails);
// Assert.NotNull(dependent.Order);
// var principal = dependent.Order;
//
// var subDependent1Entry = context.Entry(subDependent1);
// Assert.Equal(principal.Id, subDependent1Entry.Property("OrderDetailsId").CurrentValue);
// Assert.Equal(typeof(OrderDetails).DisplayName() + "." + nameof(OrderDetails.BillingAddress) + "#" + typeof(Address).ShortDisplayName(), subDependent1Entry.Metadata.Name);
//
// var subDependent2Entry = context.Entry(subDependent2);
// Assert.Equal(principal.Id, subDependent2Entry.Property("OrderDetailsId").CurrentValue);
// Assert.Equal(typeof(OrderDetails).DisplayName() + "." + nameof(OrderDetails.ShippingAddress) + "#" + typeof(Address).ShortDisplayName(), subDependent2Entry.Metadata.Name);
// });
}
public void Query_dependent_include_principal()
{
Seed();
using (var context = new QueryFixupContext())
{
var dependent = context.Set <Product>().Include(e => e.Category).Single();
var principal = dependent.Category;
AssertFixup(
context,
() =>
{
Assert.Equal(principal.Id, dependent.CategoryId);
Assert.Same(principal, dependent.Category);
Assert.Equal(new[] { dependent }.ToList(), principal.Products);
});
}
}
public void Query_dependent_include_principal_self_ref_unidirectional()
{
Seed();
using (var context = new QueryFixupContext())
{
var widgets = context.Set <WidgetDN>().Include(e => e.ParentWidget).ToList();
var dependent = widgets.Single(e => e.Id == 78);
var principal = widgets.Single(e => e.Id == 77);
AssertFixup(
context,
() =>
{
Assert.Equal(principal.Id, dependent.ParentWidgetId);
Assert.Same(principal, dependent.ParentWidget);
});
}
}
public void Query_principal_include_dependent_multiple_relationships()
{
Seed();
using var context = new QueryFixupContext();
var principal = context.Set <Blog>().Include(e => e.Posts).Single();
var dependent = principal.Posts.Single();
AssertFixup(
context,
() =>
{
Assert.Equal(principal.Id, dependent.BlogId);
Assert.Same(principal, dependent.Blog);
Assert.Equal(new[] { dependent }.ToList(), principal.Posts);
Assert.Equal(dependent.Id, principal.TopPostId);
Assert.Same(dependent, principal.TopPost);
});
}
public void Query_principal_include_dependent_self_ref_unidirectional()
{
Seed();
using (var context = new QueryFixupContext())
{
var widgets = context.Set<WidgetPN>().Include(e => e.ChildWidgets).ToList();
var dependent = widgets.Single(e => e.Id == 78);
var principal = widgets.Single(e => e.Id == 77);
AssertFixup(
context,
() =>
{
Assert.Equal(principal.Id, dependent.ParentWidgetId);
Assert.Equal(new[] { dependent }.ToList(), principal.ChildWidgets);
});
}
}
public void Query_self_ref_one_to_one_dependent_nav_only()
{
Seed();
using (var context = new QueryFixupContext())
{
var smidgets = context.Set<SmidgetDN>().ToList();
var dependent = smidgets.Single(e => e.Id == 78);
var principal = smidgets.Single(e => e.Id == 77);
AssertFixup(
context,
() =>
{
Assert.Equal(principal.Id, dependent.ParentSmidgetId);
Assert.Same(principal, dependent.ParentSmidget);
});
}
}
public void Query_principal_include_dependent_unidirectional_one_to_one()
{
Seed();
using (var context = new QueryFixupContext())
{
var principal = context.Set<ParentPN>().Include(e => e.Child).Single();
var dependent = principal.Child;
AssertFixup(
context,
() =>
{
Assert.Equal(principal.Id, dependent.ParentId);
Assert.Same(dependent, principal.Child);
});
}
}
public void Query_principal_include_dependent_multiple_relationsships()
{
Seed();
using (var context = new QueryFixupContext())
{
var principal = context.Set<Blog>().Include(e => e.Posts).Single();
var dependent = principal.Posts.Single();
AssertFixup(
context,
() =>
{
Assert.Equal(principal.Id, dependent.BlogId);
Assert.Same(principal, dependent.Blog);
Assert.Equal(new[] { dependent }.ToList(), principal.Posts);
Assert.Equal(dependent.Id, principal.TopPostId);
Assert.Same(dependent, principal.TopPost);
});
}
}
public void Query_dependent_include_principal_one_to_one()
{
Seed();
using (var context = new QueryFixupContext())
{
var dependent = context.Set<Child>().Include(e => e.Parent).Single();
var principal = dependent.Parent;
AssertFixup(
context,
() =>
{
Assert.Equal(principal.Id, dependent.ParentId);
Assert.Same(principal, dependent.Parent);
Assert.Same(dependent, principal.Child);
});
}
}
public void Query_self_ref()
{
Seed();
using (var context = new QueryFixupContext())
{
var widgets = context.Set<Widget>().ToList();
var dependent = widgets.Single(e => e.Id == 78);
var principal = widgets.Single(e => e.Id == 77);
AssertFixup(
context,
() =>
{
Assert.Equal(principal.Id, dependent.ParentWidgetId);
Assert.Same(principal, dependent.ParentWidget);
Assert.Equal(new[] { dependent }.ToList(), principal.ChildWidgets);
});
}
}
public void Query_principal_include_dependent_self_ref_one_to_one_unidirectional()
{
Seed();
using (var context = new QueryFixupContext())
{
var smidgets = context.Set<SmidgetPN>().Include(e => e.ChildSmidget).ToList();
var dependent = smidgets.Single(e => e.Id == 78);
var principal = smidgets.Single(e => e.Id == 77);
AssertFixup(
context,
() =>
{
Assert.Equal(principal.Id, dependent.ParentSmidgetId);
Assert.Same(dependent, principal.ChildSmidget);
});
}
}
