Entity Framework Plus LINQ Dynamic

Description

LINQ Dynamic in Entity Framework is supported through the Eval-Expression.NET Library. That feature is free to use even for commercial use.

Predicate

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

• Deferred
  • OrderByDescendingDynamic
  • OrderByDynamic
  • SelectDynamic
  • SelectMany
  • SkipWhileDynamic
  • TakeWhileDynamic
  • ThenByDescendingDynamic
  • ThenByDynamic
  • WhereDynamic
• Immediate
  • AllDynamic
  • AnyDynamic
  • CountDynamic
  • FirstDynamic
  • FirstOrDefaultDynamic
  • LastDynamic
  • LastOrDefaultDynamic
  • LongCountDynamic
  • SingleDynamic
  • SingleOrDefaultDynamic

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

Try it

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

Try it

Execute

The Execute method is the LINQ Dynamic ultimate method which lets 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