Conditional WHERE in LINQ

Question

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.

Answer 1

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));