Entity Framework Plus LINQ Dynamic

This feature is now available on Entity Framework Classic - LINQ Dynamic. Entity Framework Classic is a supported version from the latest EF6 code base. It supports .NET Framework and .NET Core and overcomes some EF limitations by adding tons of must-haves built-in features.

Introduction

LINQ Dynamic in Entity Framework is supported through the Eval-Expression.NET Library.

Predicate

All LINQ predicate methods are supported. A string expression which return a Boolean function can be used as parameter.

• Deferred
• SkipWhile
• TakeWhile
• Where
• Immediate
• All
• Any
• Count
• First
• FirstOrDefault
• Last
• LastOrDefault
• LongCount
• Single
• SingleOrDefault

var list = ctx.Where(x => "x > 2").ToList();
var list = ctx.Where(x => "x > y", new { y = 2 }).ToList();

Try it online

Order && Select

All LINQ selector and order are supported. Most of them require the "Dynamic" suffix to not override default behavior (Ordering or selecting by a string is valid).

• OrderByDescendingDynamic
• OrderByDynamic
• SelectDynamic
• SelectMany
• ThenByDescendingDynamic
• ThenByDynamic

var list = context.Customers.OrderByDescendingDynamic(x => "x.Name").ToList();
var list = context.Customers.SelectDynamic(x => "x.Name").ToList();

Try it online

Execute

The Execute method is the LINQ Dynamic ultimate methods which let you evaluate and execute a dynamic expression and return the result.

• Execute
• Execute< TResult >

var list = ctx.Execute<IEnumerable<int>>("Where(x => x > 2)");
var list3 = ctx.Execute("Where(x => x > y).OrderBy(x => x).ToList()", new { y = 2 });

Try it online