Query from using a List
-
I have a container that I want to query all elements that have a parameter that matches any of the items in a List. Do I have to loop through my list and requery every loop or can this be done in one line? e.g.
List[int] matchingParams = GetMatchingParams();
MyDataTable data = GetMyDataTable(); //Has an integer column we want to match to, lets call it intMatchvar results = from rows in data
where rows.intMatch == (ANY OF THE ITEMS IN matchingParams)
select rows; -
I have a container that I want to query all elements that have a parameter that matches any of the items in a List. Do I have to loop through my list and requery every loop or can this be done in one line? e.g.
List[int] matchingParams = GetMatchingParams();
MyDataTable data = GetMyDataTable(); //Has an integer column we want to match to, lets call it intMatchvar results = from rows in data
where rows.intMatch == (ANY OF THE ITEMS IN matchingParams)
select rows;You may just be able to do a .Contains() i.e.:
List[int] matchingParams = GetMatchingParams();
MyDataTable data = GetMyDataTable(); //Has an integer column we want to match to, lets call it intMatch
var results = from rows in data
where matchingParams.Contains(rows.intMatch)
select rows; -
You may just be able to do a .Contains() i.e.:
List[int] matchingParams = GetMatchingParams();
MyDataTable data = GetMyDataTable(); //Has an integer column we want to match to, lets call it intMatch
var results = from rows in data
where matchingParams.Contains(rows.intMatch)
select rows;