EF Query With Conditional Include

by

I’ve been planning on writing a tip on this but your question beat me to the punch.

Assuming a WorkItem has many WorkItemNotes

you can do this:

var intermediary = (from item in ctx.WorkItems
              from note in item.Notes
              where note.SomeProp == SomeValue
              select new {item, note}).AsEnumerable();

This produces an anonymous element for each WorkItemNote that matches, and holds the corresponding WorkItem too.

EF identity resolution insures that the same WorkItem (by reference) is returned multiple times if it has multiple WorkItemNotes that match the criteria.

I assume that next you want to just get back to just the WorkItems, like this:

var workItems = intermediary.Select(x => x.item).Distinct().ToList();

Then if you now do this:

foreach(var workItem in workItems)
{
   Console.WriteLine(workItem.Notes.Count)
}

You will see that WorkItemNotes that match the original filter have been added to the Notes collection of each workItem.

This is because of something called Relationship Fixup.

I.e. this gives you what you want conditional include.

Hope this helps

Alex

More Related Contents:

  1. EF Core Second level ThenInclude missworks
  2. The relationship could not be changed because one or more of the foreign-key properties is non-nullable
  3. Disable lazy loading by default in Entity Framework 4
  4. Best way to check if object exists in Entity Framework? [closed]
  5. How to select top N rows for each group in a Entity Framework GroupBy with EF 3.1
  6. EF5 Code First Enums and Lookup Tables
  7. Entity Framework 4.1 DbContext Override SaveChanges to Audit Property Change
  8. Entity Framework One-To-One Mapping Issues
  9. Multi-async in Entity Framework 6?
  10. How do you ensure Cascade Delete is enabled on a table relationship in EF Code first?
  11. ef core 2 apply HasQueryFilter for all entity
  12. Value cannot be null. Parameter name: entitySet
  13. SQL Server Express connection string for Entity Framework Code First
  14. Entity Framework Code First – Advantages and disadvantages of Fluent Api vs Data Annotations [closed]
  15. EF Code First giving me error Cannot insert explicit value for identity column in table ‘People’ when IDENTITY_INSERT is set to OFF. [duplicate]
  16. EF Code First DBContext and Transactions
  17. How can I disable migration in Entity Framework 6.0
  18. How do I use Entity Framework in Code First Drop-Create mode?
  19. Many to Many Relationships not saving
  20. EF Code First foreign key without navigation property
  21. Nullable property to entity field, Entity Framework through Code First
  22. LINQ to Entities for subtracting 2 dates
  23. Entity Framework Code First Using Guid as Identity with another Identity Column
  24. AutomaticMigrationsEnabled false or true?
  25. ADO.NET Entity Framework tutorials [closed]
  26. Entity Framework Code First Many to Many Setup For Existing Tables
  27. Compose queries across Entity Data Models
  28. Changing Inherited Types in Entity Framework
  29. Why is my Entity Framework Code First proxy collection null and why can’t I set it?
  30. Why does the entity framework need an ICollection for lazy loading?

Leave a Comment