How to make an Expression tree that works similarly to "StartsWith"

.net c# expression-trees lambda vb.net

Question

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.

1
8
12/29/2010 2:29:52 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

using System;
using System.Linq;
using System.Linq.Expressions;
using System.Reflection;

namespace WindowsFormsApplication1
{
    static class Program
    {
        [STAThread]
        static void Main()
        {
            using (var context = new NorthwindEntities())
            {
                PropertyInfo propertyInfo = typeof(Customer).GetProperty("CustomerID"); 

                IQueryable<Customer> query = context.Customers;
                query = ETForStartsWith<Customer>(query, "A", propertyInfo); 
                var list = query.ToList();
            }
        }

        static IQueryable<T> ETForStartsWith<T>(IQueryable<T> query, string propertyValue, PropertyInfo propertyInfo)
        {
            ParameterExpression e = Expression.Parameter(typeof(T), "e");
            MemberExpression m = Expression.MakeMemberAccess(e, propertyInfo);
            ConstantExpression c = Expression.Constant(propertyValue, typeof(string));
            MethodInfo mi = typeof(string).GetMethod("StartsWith", new Type[] { typeof(string) });
            Expression call = Expression.Call(m, mi, c);

            Expression<Func<T, bool>> lambda = Expression.Lambda<Func<T, bool>>(call, e); 
            return query.Where(lambda);
        }
    }
}
20
12/29/2010 1:27:12 PM

Popular Answer

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").

fejesjoco

Related Questions

In C#, how can I represent 'String.Contains("term")' with an expression tree?

Something like:...class Foo { public string Bar { get; set; } } static void Main() { var lambda = GetExpression<Foo>("Bar", "abc"); Foo foo = new Foo { Bar = "aabca" }; bool test = lambda.Compile()(foo); } static Expression<Func<T, bool>> GetExpression<T>(string propertyName, string propertyValue) { var parameterExp = Expression...
.net c# expression-trees lambda
asked by Marc Gravell

I'm not sure how to make an expression tree using IEnumerableTSource>. Any(...)?

There are several things wrong with how you're going about it....You're mixing abstraction levels. The T parameter to ...GetAnyExpression<T>... could be different to the type parameter used to instantiate ...propertyExp.Type.... The T type parameter is one step closer in the abstraction stack to compile time - unless you're calling ...GetAnyExpress...
.net c# expression-trees linq
asked by Barry Kelly

Create a completely dynamic where clause using an expression tree and run it via IQueryable.

At point (3) in my code I have defined a query called query1 in which I defined a .Where lambda expression. This query is in some way dynamic but still contains static elements, it always refers to the Type Employee and its (int) property ClientID. ...Now I very much like to make the refering to the type and its property dynamic, based on the metho...
c# expression-trees iqueryable lambda where
asked by Wouter Vegter

An expression tree may be sent as a parameter to another expression tree.

I have two expression trees defined like this:...private Expression<Func<TEntity, TPropertyResult>> PropertyAccessor { get; set; } ...and...private Expression<Func<TPropertyResult, bool>> TestExpression { get; set; } ...I need to create a new expression tree that will result in the equivalent of:...var expression = p => this.TestExpression(this.Pro...
c# expression-trees lambda
asked by Pierre-Alain Vigeant

Why can't I manually generate the same Expression Tree that my straight lambda does?

I've gone through and beat my head against the wall for a while now searched on various phrases and keywords but I cannot find anything close to an answer so i'm hoping someone here can shed some light....Basically I'm working on diving pretty deep into manipulating, creating, and modifying Expression Trees in C# 4.0...I came across an odd anomaly ...
c# expression-trees lambda
asked by TofuBug

How can I create a LINQ-friendly 'return false' expression using C# expression trees?

Expression<Func<T, bool>> falsePredicate = x => false;
.net c# expression-trees linq
asked by Rui Jarimba

Create an Expression Tree that generates a parametric query for Entity Framework

I'm trying to create a generic class to be used to compose queries for Entity Framework (5)....I got it to work, the only problem is that the value is injected as a constant of the query instead of as a parameter. This reduces the possibilities for EF to cache the query and reuse it later on....This is what I got so far....public class MinDateFilte...
entity-framework expression-trees
asked by Kralizek

How can I create an Expression tree that compares properties in a child object?

How can I create an Expression tree that compares properties in a child object?...For example, I already can create a lambda expression tree that compares direct properties of an object. Like this:...var propertyName = "JobNumber"; var propertyValue = "1005"; Type entityType = typeof(ParentObject); OperatorDelegate comparisonMethod = Expression.Equ...
c# expression-trees lambda
asked by quakkels

Explicit conversion of parameters in Expression Trees created from MethodInfo

I have the method below which converts a (non-static) ...MethodInfo... into a compiled Expression (...Func...) which I can then call....This works great: I can call it with a method expecting both reference objects and value types....BUT unlike the original method where I could call a method that had a parameter expecting a ...double... and pass it...
c# expression-trees
asked by Ian Mercer

Create Lambda Expression Selector For New Class Using Expression Tree

Related To:...Create Expression Tree For Selector...Create a Lambda Expression With 3 conditions...Convert Contains To Expression Tree...Convert List.Contains to Expression Tree...I want to Create ...Selector... expression using ...Expression Tree... for new class. Please Consider this code:...s => new Allocation { Id = s.Id, ...
c# c#-6.0 expression-trees lambda linq
asked by Arian

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