How do I do IN syntax with Linq

Question

I need to do this using linq chaining syntax. I have:

string[] arr = new string[] {"Chicago", "NewYork"};

var a = Members.Where(x => x.City == <here I want to get all members in chicago or newyork)

Answer 1

You can use a simple Contains.

var a = Members.Where(x => arr.Contains(x.City));

Answer 2

I know this is old, but I thought this would help new readers of this post.

Similar to code4life, I use an extension method. The difference, though, is that I use generics so this will work with multiple types.

You can read my blog post to see more information about how to do this, but the main idea is this:

By adding this extension method to your code:

public static bool IsIn<T>(this T source, params T[] values)
{
    return values.Contains(source);
}

you can perform your search like this:

var a = Members.Where(x => x.City.IsIn("Chicago", "NewYork");

It works on any type (as long as you create a good equals method). Any value type for sure.