Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to create an Expression tree to do the same as "StartsWith"

Currently, I have this method to compare two numbers

Private Function ETForGreaterThan(ByVal query As IQueryable(Of T), ByVal propertyValue As Object, ByVal propertyInfo As PropertyInfo) As IQueryable(Of T)

    Dim e As ParameterExpression = Expression.Parameter(GetType(T), "e")
    Dim m As MemberExpression = Expression.MakeMemberAccess(e, propertyInfo)
    Dim c As ConstantExpression = Expression.Constant(propertyValue, propertyValue.GetType())
    Dim b As BinaryExpression = Expression.GreaterThan(m, c)
    Dim lambda As Expression(Of Func(Of T, Boolean)) = Expression.Lambda(Of Func(Of T, Boolean))(b, e)
    Return query.Where(lambda)

End Function

It works fine and is consumed in this way

query = ETForGreaterThan(query, Value, propertyInfo)

As you can see, I give it an IQueryable collection and it add a where clause to it, base on a property and a value. Y can construct Lessthan, LessOrEqualThan etc equivalents as System.Linq.Expressions.Expression has this operators predefined.

¿How can I transform this code to do the same with strings? System.Linq.Expressions.Expression don't give me a predefined operator like "contains" or "startwith" and I'm really noob with Expression trees.

Thanks, and please Post your answer in C#/VB. Choose the one that make you feel more confortable.

like image 974
Jonathan Avatar asked Dec 29 '10 11:12

Jonathan


1 Answers

It's not an operator, but a method, so you can call it with Expression.Call(), where the methodinfo parameter will be typeof(string).GetMethod("StartsWith").

like image 124
fejesjoco Avatar answered Oct 02 '22 04:10

fejesjoco