In Expression Trees, working with nullable types

c# entity-framework expression-trees lambda linq


I have a method modification to filter Linq to Entities results using string values dynamically. Up till I use it to filter nullable columns, it works well. Below is my code:

public static IOrderedQueryable<T> OrderingHelperWhere<T>(this IQueryable<T> source, string columnName, object value)
    ParameterExpression table = Expression.Parameter(typeof(T), "");
    Expression column = Expression.PropertyOrField(table, columnName);
    Expression where = Expression.GreaterThanOrEqual(column, Expression.Constant(value));
    Expression lambda = Expression.Lambda(where, new ParameterExpression[] { table });

    Type[] exprArgTypes = { source.ElementType };

    MethodCallExpression methodCall = Expression.Call(typeof(Queryable), 

    return (IOrderedQueryable<T>)source.Provider.CreateQuery<T>(methodCall);

This is how I apply it:

var results = (from row in ctx.MyTable select row)
              .OrderingHelperWhere("userId", 5);//userId is nullable column

The error message I get when using this for nullable table columns is as follows:

The binary operator GreaterThanOrEqual is not defined for the types 'System.Nullable`1[System.Int32]' and 'System.Int32'

I was unable to figure this out. What ought I to do?

4/7/2017 12:06:39 AM

Accepted Answer

I have to use Expression to change the value type to the column type. Convert:

Expression where = Expression.GreaterThanOrEqual(column, Expression.Convert(Expression.Constant(value), column.Type));
10/7/2010 12:23:08 PM

Related Questions


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