CODEWITHSUNDEEP
c#linqentity-frameworkt-sqllinq-to-entities
Jon H
Jon H

Reputation: 1071

Conditional WHERE in LINQ

Hi any suggestions on building a LINQ statement based on search criteria?

I'll be passing in an instance of a 'SearchCriteria' class with all parameters nullable.

I then want to 

if (sc.a != null)
    // add to where

if (sc.b != null)
    // add to where

The key thing is these are to be ORs not ANDs.

Any tips?

And for bonus points I'd like to use 'contains' on an int? but I can only get equals or not equals.

Upvotes: 7

Views: 10626

Answers (1)

abatishchev
abatishchev

Reputation: 100238

Try:

.Where(x =>
    (x.a != null ? x.a == a : false) &&
    (x.b != null ? x.b == b : false));

or

.Where(x =>
    (x.a != null && x.a == a) ||
    (x.b != null && x.b == b));

Also:

.Where(x => new int[] { 1, 2, 3 }.Contains(x.i));

Upvotes: 7

Related Questions