How to filter “Include” entities in entity framework?

by

There are two ways to filter include Entity.

  • Using a projection (See @Eldho answer)
  • Using a third party library

Disclaimer: I’m the owner of the project Entity Framework Plus

The EF+ Query IncludeFilter allows to easily filter included entities.

context.Entry(hotel)
       .Collection(x => x.Rooms)
       .Query()
       .IncludeFilter(y => y.Reservations
                            .Where(z => z is ExecutiveSuite && z.Reservations.Any())
       .Load();

Under the hood, the library does exactly a projection.

Wiki: EF+ Query Include Filter

EDIT: Answer subquestion

You almost did it. The rooms were included and filtered, but you didn’t include the reservations.

var hotel = context.Hotels
    // Include only executive suite with a reservation
    .IncludeFilter(x => x.Rooms.Where(y => y is ExecutiveSuite && y.Reservations.Any()))
    // Include only reservation from executive suite
    .IncludeFilter(x => x.Rooms.Where(y => y is ExecutiveSuite).Select(z => z.Reservations))
    .First();

EDIT: Answer Comment

How can we include multilevel properties with include filter

You can include multilevel by specifying each path (one per IncludeFilter)

So qry.Include("Rooms.Hotel") become:

qry.IncludeFilter(x => x.Rooms)
   .IncludeFilter(x => x.Rooms.Select(y => y.Hotel))

EDIT: Answer Comment

does EF+ have dotnet 5.0 support?

Yes, it supports dotnet 5.0 and EF Core 5.0. However, for IncludeFilter, you should also look at the filtered include built-in directly in EF Core 5: https://www.learnentityframeworkcore5.com/whats-new-in-ef-core-5/filtered-included

More Related Contents:

  1. Entity Framework Provider type could not be loaded?
  2. How to update record using Entity Framework 6?
  3. EF Code-First One-to-one relationship: Multiplicity is not valid in Role * in relationship
  4. Entity Framework 6 GUID as primary key: Cannot insert the value NULL into column ‘Id’, table ‘FileStore’; column does not allow nulls
  5. Mapping composite keys using EF code first
  6. Setting unique Constraint with fluent API?
  7. Lazy Loading vs Eager Loading
  8. Entity Framework 6: audit/track changes
  9. Dynamic MySQL database connection for Entity Framework 6
  10. Entity Framework 6 Code First Custom Functions
  11. DbSet.Attach(entity) vs DbContext.Entry(entity).State = EntityState.Modified
  12. Problems using Entity Framework 6 and SQLite
  13. Database.BeginTransaction vs Transactions.TransactionScope [duplicate]
  14. Save detached entity in Entity Framework 6
  15. Eager , Lazy and explicit loading in EF6
  16. Configure multiple database Entity Framework 6
  17. Entity Framework 6 transaction rollback
  18. Log Queries executed by Entity Framework DbContext
  19. How are people unit testing with Entity Framework 6, should you bother?
  20. Async PartialView causes “HttpServerUtility.Execute blocked…” exception
  21. How to group by DateTime.Date in EntityFramework
  22. How to use String property as primary key in Entity Framework
  23. How does the SQLite Entity Framework 6 provider handle Guids?
  24. How can set a default value constraint with Entity Framework 6 Code First?
  25. Entity Framework Core: A second operation started on this context before a previous operation completed
  26. Retrieve an object from entityframework without ONE field
  27. Export Model to DataTable
  28. Exclude Property on Update in Entity Framework
  29. User in Entity type MVC5 EF6
  30. Keyword Not Supported: Metadata

Leave a Comment