Entity Framework Dynamic 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

• Entity Framework Dynamic LINQ
• Entity Framework Dynamic Where Clause
• Entity Framework OrderBy String

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