What is the linq equivalent to the SQL IN operator

sql linq contains
Luca Romagnoli picture Luca Romagnoli · Feb 25, 2010 · Viewed 34.9k times · Source

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 it?

Answer

David Morton picture David Morton · Feb 25, 2010

.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

Related questions

Entity Framework. Delete all rows in table

How I can quickly remove all rows in table using Entity Framework? I am currently using: var rows = from o in dataDb.Table select o; foreach (var row in rows) { dataDb.Table.Remove(row); } dataDb.SaveChanges(); However, it takes a …

Read More
LINQ to Entities does not recognize the method 'System.String ToString()' method, and this method cannot be translated into a store expression

I'm migrating some stuff from one mysql server to a sql server but i can't figure out how to make this code work: using (var context = new Context()) { ... foreach (var item in collection) { IQueryable<entity> pages = from p …

Read More
SQL to LINQ Tool

Is there a tool out there which can convert SQL syntax to LINQ syntax? I just want to rewrite basic queries with join, etc., to LINQ. It would save me a lot of time.

Read More