use select and where in linq c# example
Example: linq query select where c#
var queryLondonCustomers = from cust in customers
where cust.City == "London"
select cust;
var queryLondonCustomers = from cust in customers
where cust.City == "London"
select cust;