c# Lambda Expression - Get property value from string [duplicate]

Question

Consider following lambda expression:

IQueryable<Product> query = query.Where(x => x.ProductName.Contains("P100"));

I need to convert above code something like this:

IQueryable<Product> query = query.Where(x => x.GetPropertyValue("ProductName").Contains("P100"));

Here I have added a dummy method GetPropertyValue("ProductName") to explain the requirement. In above code the property should be resolved in run-time. In other words I need to access the property from a sting value E.g "ProductName"

How can I do this?

I mean I have to make this method more generic. According to my application logic I only have the property name as a string value. So i need to resolve the string as a property. — Rahul
– Rahul, Commented Mar 27, 2016 at 8:06
What's your query processor? Will it even support using a GetPropertyValue() method on a Product object? There's no point in doing the conversion if it's not supported. — Jeff Mercado
– Jeff Mercado, Commented Mar 27, 2016 at 8:25
You need to learn either Linq Expressions, or you need to use Dynamic Linq. — Aron
– Aron, Commented Mar 27, 2016 at 9:40
@DavidG This is a completely different question from the one you are referencing, given that using Reflection will not work with most Linq Providers. — Aron
– Aron, Commented Mar 1, 2018 at 17:58

Aron · Accepted Answer · 2016-03-27 09:51:39Z

9

var parameterExp = Expression.Parameter(typeof(Product), "type");
var propertyExp = Expression.Property(parameterExp, propertyName);
MethodInfo method = typeof(string).GetMethod("Contains", new[] { typeof(string) });
var someValue = Expression.Constant(propertyValue, typeof(string));
var containsMethodExp = Expression.Call(propertyExp, method, someValue);

Expression<Func<Product, bool>> predicate = Expression.Lambda<Func<T, bool>>
             (containsMethodExp, parameterExp);


var query = query.Where(predicate);

edited Mar 27, 2016 at 9:51

answered Mar 27, 2016 at 9:46

Aron

15.8k3 gold badges34 silver badges71 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Douglas Gaskell Over a year ago

Can this easily transferred to just a linq where call without the contains bit?

Aron Over a year ago

@DouglasGaskell What do you mean without the contains bit? The above code is for generating a pure Linq expression tree without any CLR. Which allows this query to run in most Linq Providers including non CLR backed providers like EF or nHiberate.

Jcl · Accepted Answer · 2016-03-27 09:51:00Z

1

You can have this extension method:

public static T GetPropertyValue<T>(this Product product, string propName)
{
   return (T)typeof(Product).GetProperty(propName).GetValue(product, null);
}

Then:

IQueryable<Product> query = query.Where(x => x.GetPropertyValue<string>("ProductName").Contains("P100"));

Notice that this will not work with Entity Framework to query a database, but since you haven't tagged the question with entity framework, I'm not assuming you are using it

answered Mar 27, 2016 at 9:51

Jcl

28.4k5 gold badges66 silver badges97 bronze badges

2 Comments

Rahul Over a year ago

I'm using Odata V4 with Odata Client code generator. will this work?

Jcl Over a year ago

I never used it, I don't know, but if it's pertinent to the question (and it is), you should have specified it (or at least tagged the question)

Collectives™ on Stack Overflow

c# Lambda Expression - Get property value from string [duplicate]

2 Answers 2

2 Comments

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Linked

Related