Luca Romagnoli Luca Romagnoli - 3 months ago 18
SQL Question

What is the linq equivalent to the SQL IN operator

With linq I have to check if a value of a row is present in an array.

The equivalent of the sql query:

WHERE ID IN (2,3,4,5)


How can I do?

Answer

.Contains

var resultset = from x in collection where new[] {2,3,4,5}.Contains(x) select x

Of course, with your simple problem, you could have something like:

var resultset = from x in collection where x >= 2 && x <= 5 select x
Comments