LINQ to Entities - Common queries (.Net 4.0)
Posted by Anders Vindberg
in Lunarmedia Blog
on the 13 Mar. 2010 (163,721 views).
T-Sql "WHERE IN":
Sql:
SELECT * FROM People
WHERE Firstname IN ('Peter', 'Steve', 'John', 'Bruno')
LINQ:
var names = new string[] { "Peter", "Steve", "John", "Bruno" };
var matches = from person in people
where names.Contains(person.Firstname)
select person;