Entity Framework Include Filter Library


Entity Framework Include Filter library allow you to add a method similar to EF Include but with a predicate to filter related entities.

Why using Include Filter with Entity Framework?

Common scenario:

  • Logical Data Partitioning
  • Multi-Tenancy
  • Soft Deleted
  • Security Access

Google – Related Searches

Stack Overflow – Related Questions


// using Z.EntityFramework.Plus; // Don't forget to include this.
var ctx = new EntitiesContext();
// LOAD orders and the first 10 active related entities.
var list = ctx.Orders.IncludeFilter(x => x.Items.Where(y => !y.IsSoftDeleted)
.OrderBy(y => y.Date)

Supported Library

Library Type EF Version Support Doc Features
Z.EntityFramework.Plus FREE EF5
EF Core
< 1 Day Yes
  • Audit
  • Batch Delete
  • Batch Update
  • Cache
  • Deferred Query
  • Filter
  • Future
  • Include Filter
  • Include Optimized