Dynamic expression on List

c# dynamic-linq expression lambda

Question

Given the following classes 

public class ClassA
{
    public string StringProperty { get; set; }

    public List<ClassB> List { get; set; }
}

public class ClassB 
{
    public int IntProperty { get; set; }
}

I Would like to dynamically create an expression like the following

x => x.StringProperty == "X" && x.List.Any( y => y.IntProperty > 1 )

No problem for the first part (x.StringProperty == "X"). For the second part I have created a member expression corresponding to x.List and now need to

  1. Create the inner lambda. To do this I need to know the type of y which is actually the same inner type of x.List
  2. Call the Any method on the x.List expression

Any hint on the first point? How do I get the type T of an IEnumerable<T>?

EDIT

I have tried with the following code but it returns null unfortunately

//This expression will be x.List of my original sample 
MemberExpression expr = GetMemberExpression( property, pe );

Type innerType = expr.GetType()
                     .GetInterfaces()
                     .Where( t => t.IsGenericType == true && t.GetGenericTypeDefinition() == typeof( IEnumerable<> ) )
                     .Select( t => t.GetGenericArguments()[0] )
                     .SingleOrDefault();
1
0
5/8/2017 12:25:53 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

Given

private static readonly MethodInfo anyT = (from x in typeof(Enumerable).GetMethods(BindingFlags.Public | BindingFlags.Static)
                                            where x.Name == nameof(Enumerable.Any) && x.IsGenericMethod
                                            let gens = x.GetGenericArguments()
                                            where gens.Length == 1
                                            let pars = x.GetParameters()
                                            where pars.Length == 2 &&
                                                pars[0].ParameterType == typeof(IEnumerable<>).MakeGenericType(gens[0]) &&
                                                pars[1].ParameterType == typeof(Func<,>).MakeGenericType(gens[0], typeof(bool))
                                            select x).Single();

// https://stackoverflow.com/a/906513/613130
private static IEnumerable<Type> GetGenericIEnumerables(Type type)
{
    return type.GetInterfaces()
                .Where(t => t.IsGenericType == true
                    && t.GetGenericTypeDefinition() == typeof(IEnumerable<>))
                .Select(t => t.GetGenericArguments()[0]);
}

Then you can:

var parX = Expression.Parameter(typeof(ClassA), "x");

var list = Expression.Property(parX, nameof(ClassA.List));

var listType = list.Type;
var baseType = GetGenericIEnumerables(listType).First();

var parY = Expression.Parameter(baseType, "y");

var eq = Expression.Equal(
    Expression.Property(parX, nameof(ClassA.StringProperty)),
    Expression.Constant("X"));

var gt = Expression.GreaterThan(
    Expression.Property(parY, "IntProperty"),
    Expression.Constant(1));

var innerExpression = Expression.Lambda(gt, parY);

var any = Expression.Call(
    anyT.MakeGenericMethod(baseType),
    list,
    innerExpression);

var and = Expression.AndAlso(eq, any);

var outerExpression = Expression.Lambda<Func<ClassA, bool>>(and, parX);

var compiled = outerExpression.Compile();

var result = objs.Where(compiled).ToArray();

Note that you don't need to compile the innerExpression: the outerExpression.Compile() will do everything for you!

I'm using a modified version of getting type T from IEnumerable<T> to find the T of a IEnumerable<T>.

1
5/23/2017 12:34:30 PM

Related Questions

Does dynamic GroupBy in dynamic LINQ work with dynamic Where?

I use this ...dynamic LINQ library... together with Linq-to-Entities.... I build query and after that iterate it with ...foreach(object e in query){}...query=db.Table1.Where("it.FieldA>10").Select("it.FieldB");... works....query=db.Table1.Where(e=>e.FieldA>10).GroupBy("it.FieldB", "it").Select("key")... works.... But ...query=db.Table1.Where("it.Fi...
.net dynamic dynamic-linq linq linq-to-entities
asked by alpav

How to add an AND/OR expression to the following dynamic linq expression

I'm not quite sure if I have understood you correctly, but I think I was in the same situation a few months ago. The posted code ... here ... was my solution....I think you should be especially interested in line 24....Edit:...PropertyInfo p = ... // I used reflection in my examply to get properties with a certain Attribute var expressionParameter...
.net c# dynamic-linq expression-trees linq
asked by MarcusK

How to create dynamic-linq where for a List of Dictionary?

I've been using dynamic-linq to filter a list of object using a simple Where clause:...public class Employee { public int Age = 0; public string FirstName = ""; } var list1 = new List<Employee>(); for (int i = 0; i < 100; i++) { list1.Add(new Employee() { Age = i, FirstName = "FirstName-" + i }); } IQueryable<Em...
c# dynamic-linq
asked by The_Black_Smurf

How to create dynamic entity framework filter expression like Expression<Func<T, bool>>

I want to create a dynamic lambda expressions for filtering. ...I searched little bit but could not find useful stuff for child collections. So how can I create an expression like that?...Expression<Func<ORDERS, bool>> filter1 = c => c.ORDER_DETAILS.Any(x => x.PRODUCTS.HEADING.Contains("foo")); ...PS: I asked similar question like that but i didn't...
c# dynamic-linq entity-framework lambda linq
asked by Kadir

Using Linq.Dynamic where method with a dynamic list gives error

I am reading some JSON and converting it to a dynamic list. Below is My Code:...dynamic data = JObject.Parse(response); var result = data.result; var result = ((IEnumerable)arr).Cast<dynamic>().ToList(); var id = result[0].id; var filtereddata = result.Where("id==1"); ...The line...var filtereddata = result.Where("id==1"); ...Gives error ...No pro...
c# dynamic dynamic-linq linq
asked by Anshuman Jasrotia

How to use dynamic Linq with List<dynamic> object

I have a List of dynamic objects that I am trying to use dynamic Linq on. I am using dynamic objects because I do not know the properties that will be coming into the object. Linq works on my dynamic object, but, to avoid giant hard coding if statements, I would like to use dynamic Linq to search my list. The top half of the code snippet works but ...
.net c# dynamic-linq linq
asked by Brian S

Create object containing a list using Dynamic Linq Core with Entity Framework 2.0

I have the following two classes:...public Part { public string PartNumber {get; set;} public string Description {get; set;} public List<Warehouse> Warehouses {get; set;} } public Warehouse { public string PartNumber {get; set;} public string WarehouseName {get; set;} public int Quantity {get; set;} public int ReorderPo...
c# dynamic-linq entity-framework-core list
asked by jpico

Entity Framework Dynamic Where Clause from List<object>

After scourging the internet I have not been able to find a solution that i can get to work. I am attempting to use dynamic linq to enable the user to build a custom query from a windows form. To hold each where clause I have built an object called WhereClause:...public class WhereClause { public int id { get; set; } public string ColumnNam...
c# dynamic-linq linq-to-sql
asked by LCaraway

Dynamic Projection in linq with List of fieldNames

I wanna do projection on fields of my collection and nested collection in each of entity, I use EntityFramework 6.2 I've do that with dynamic query like bellow code...Students.Select("new (Name,Family,new(Category.Name) as Category)"); ...it was worked but when I want to do that on the collection it's thrown error ... Students.Select("new (Name,F...
c# dynamic-linq entity-framework entity-framework-6 linq
asked by Masoud Mirzaei

How can I select the value and type of a dynamic list?

I have a dynamic query that brings me dynamic columns (...System.Linq.Dynamic.Core...):...var data = data.Select("new (col1, col2, col3)", "T", StringComparison.OrdinalIgnoreCase); ...[ { col1: "This", col2: 1.56, col3: "Something else" } ] ...Now I need to bring the type of each column. ex:...[ { col1: { value: "This", type: "string" }...
asp.net-core c# dynamic-linq linq
asked by Pablo

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow