How to use IN statement in linq

Question

I request a view and filters the results with a column called status. I would like to request it so that I can search for rows with different status using the IN statement, as it would in SQL.

So:

SELECT * FROM VIEW WHERE Status in ('....', '.....')

How can i achieve this?

Answer 1

If the query expression uses the Contains method of the IEnumerable , then the parser will turn it into an IN expression using the values ​​in IEnumerable .

 List<string> foo = new List<string>() { "a", "b", "c" }; var query = dataContext.View.Where(v => foo.Contains(v.Status));