Entity Framework Classic Query Include Optimized
Description
The EF Query Include Optimized feature lets you filter related entities that will be included. However, instead of to make one big query like Query Include Filter, the queries are split into several queries to optimize the performance like EF Core does.
The feature works exactly like Query Include Filter, but you use the IncludeOptimized method instead.
The query is split in multiple queries which reduce the amount of data transferred.
var customers = context.Customers.IncludeOptimized(x => x.Invoices.Where(y => !y.IsSoftDeleted)).ToList();
Try it: NET Core | NET Framework
The Query Include Optimized feature may sometimes reduce the performance. For example, when some database indexes are missing.
Download
To use this feature, you need to download the following NuGet Package
Entity Framework Classic - Integration
The Query Include Optimized feature will eventually integrate directly in Entity Framework Classic.
It's planned that this feature gets a major revamp to work more easily with include methods such as Include and IncludeFilter.
Documentation
QuerryIncludeOptimizedManager
| Name | Description | Default | Example |
|---|---|---|---|
AllowQueryBatch |
Gets or sets if queries should be batched (executed in the same SQL Command) | true |
NET Core / NET Framework |
AllowIncludeSubPath |
Gets or sets if include path should be included automatically. | false |
NET Core / NET Framework |
Extension Methods
Methods
| Name | Description | Example |
|---|---|---|
IncludeOptimized<TEntityType, TRelatedEntity>(this IQueryable<TEntityType> query, Expression<Func<TEntityType, IEnumerable<TRelatedEntity>>> filter) |
An IQueryable<TEntityType> extension method that includes and filter a collection of related entities. |
NET Core / NET Framework |
IncludeOptimized<TEntityType, TRelatedEntity>(this IQueryable<TEntityType> query, Expression<Func<TEntityType, TRelatedEntity>> filter) |
An IQueryable<TEntityType> extension method that includes and filter a single related entities. |
NET Core / NET Framework |