LINQ statement that equal to State IN ('NY','TX'...) SQL Statement

[Shimon Sim]

Is it possible to write LINQ statement (LINQ to SQL) that would result in
query with IN key word.
Like
SELECT FirstNAme, LastName FROM People WHERE State IN ('NY', 'NJ', 'TX') ?

Thanks,
Shimon.

 

[Nicholas Paldino [.NET/C# MVP]]

Shimon,

Yes, it is, but you have to turn it around in a way, and use the
Contains extension method on the set that you want to find the item in, like
so:

// The states.
string[] states = {"NY", "NJ", "TX"};

// The query.
var query = from p in people where states.Contains(p.State) select new {
p.FirstName, p.LastName };

 

[Shimon Sim]

Just did experiment and it worked!!
PeopleDataContext dc = new PeopleDataContext();
var results = from p in dc.People select p;
results = from p in results where states.Contains(p.State); // states is a
collection.

Debugging showed where State IN (@P1,@P2) . perfect!!

 

[Shimon Sim]

Thanks, I got it.

Shimon,

Yes, it is, but you have to turn it around in a way, and use the
Contains extension method on the set that you want to find the item in,
like so:

// The states.
string[] states = {"NY", "NJ", "TX"};

// The query.
var query = from p in people where states.Contains(p.State) select new {
p.FirstName, p.LastName };


--
- Nicholas Paldino [.NET/C# MVP]
- (e-mail address removed)

Is it possible to write LINQ statement (LINQ to SQL) that would result in
query with IN key word.
Like
SELECT FirstNAme, LastName FROM People WHERE State IN ('NY', 'NJ', 'TX')
?

Thanks,
Shimon.