Linq Expression to handle null

Question

I am trying to use the following code in a linq expression, which I found at this question However it fails if the database field is null.

  public static IQueryable<T> FieldsAreEqualOrBothNullOrEmpty<T>(
        this IQueryable<T> source,
        Expression<Func<T, string>> member,
        string value)
    {
        Expression body;
        if (string.IsNullOrEmpty(value))
        {
            body = Expression.Call(typeof(string), "IsNullOrEmpty", null, member.Body);
        }
        else
        {
            body = Expression.Equal(
                Expression.Call(member.Body, "ToLower", null),
                Expression.Constant(value.ToLower(), typeof(string)));
        }
        return source.Where(Expression.Lambda<Func<T, bool>>(body, member.Parameters));
    }

It looks to me as if the code

 Expression.Call(member.Body, "ToLower", null)

is the problem , but I don't know what to use in it's place.

Akash Kava · Accepted Answer · 2022-03-12 03:04:30Z

5

Expression.Call(member.Body, "ToLower", null)

should be replaced with

Expression.IfThenElse(
    Expression.Equals(member.Body, Expression.Constant(null)),
    Expression.Constant(null),
    Expression.Call(member.Body, "ToLower", null))

which translates to

body == null ? null : body.ToLower();

edited Mar 12, 2022 at 3:04

answered Oct 24, 2015 at 8:11

Akash Kava

40.1k21 gold badges126 silver badges173 bronze badges

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

3 Comments

Kirsten Over a year ago

I get Argument type bool is not assignable to parameter type 'system.linq.Expressions.Expression'

Kirsten Over a year ago

Should it be Expression.Equal not Expression.Equals ?

Kirsten Over a year ago

social.msdn.microsoft.com/Forums/en-US/… has more information.

Collectives™ on Stack Overflow

Linq Expression to handle null

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related