Saturday, October 1, 2011

"IN" operator in LINQ

SQL Query using IN operator


SELECT Members.Name
FROM Members
WHERE Members.ID IN ("1,2,3")
LINQ Query equivalent


string[] str = {"1","2"};
var list =
Members.Where(p=> str.Contains(p.ID)).Select(X => X);