Entity Framework Dynamic Query
Entity FrameworkDynamic Query
Introduction
Dynamic Query allows you to perform dynamic where clause, select, order by, with string expression at runtime.
Why Dynamic Query?
Common Scenarios:
- Use dynamic select clause with string expression
- Use dynamic order by with string expression
- Use dynamic where clause with string expression
Google Related Searches
StackOverflow Related Questions
- Building dynamic where clauses in LINQ to EF queries
- Dynamic LINQ OrderBy on IEnumerable< T >
- How to Dynamically build Select as relates to Linq & Entity Framework
- Using dynamic linq in EF Linq to Entities
- c# - Dynamically generate linq select with nested properties
var customersList1 = context.Customers
.OrderByDynamic(c => "c.Name")
.ToList();
var customersList2 = context.Customers
.Include(x => x.Invoices)
.Where(c => "c.Invoices.Count > 0")
.OrderByDescendingDynamic(c => "c.Invoices.Count")
.ToList();
Supported Libraries
Library | Type | EF Version | Support | Doc | Features |
---|---|---|---|---|---|
Z.EntityFramework.Classic | FREE/PRO | EF6 | < 1 Day | Yes | Bulk SaveChanges Bulk Insert Bulk Update Bulk Delete Bulk Merge Batch Delete Batch Update Cache Deferred Query Future |
Eval Expression.NET | FREE/PRO | All | < 1 Day | Yes | Dynamic Query |
System.Linq.Dynamic | FREE | All | < 1 Day | Yes | Dynamic Query |
漫思