Include Filter

Introduction

IncludeFilter allows you to add a method similar to EF Include but with a predicate to filter related entities.

Why IncludeFilter?

Common Scenarios:

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

Example

// 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)
.Take(10))
.ToList();

Supported Libraries

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