Use Where with .Select Linq

linq linq-to-objects
Shivi picture Shivi · Mar 17, 2011 · Viewed 56.5k times · Source

I have a scenario where i have to use .Select with where in LINQ. Below is my query.

List<DTFlight> testList = _ctrFlightList.Select(i => new DTFlight() { AirLineName = i.AirLineName,ArrivalDate = i.ArrivalDate }).ToList();

I want ti use where(add condition) to this query.

Please Help... Thanks.

Answer

Nicolas picture Nicolas · Mar 17, 2011

I suggest you this use of Where : 

List<DTFlight> testList = _ctrFlightList.
    Where(ctrFlight => ctrFlight.Property > 0).
    Select(i => new DTFlight() { AirLineName = i.AirLineName, ArrivalDate = i.ArrivalDate }).ToList();

Where returns a IEnumerable, so you can apply your Select on it.

Related questions

Sorting a list using Lambda/Linq to objects

I have the name of the "sort by property" in a string. I will need to use Lambda/Linq to sort the list of objects. Ex: public class Employee { public string FirstName {set; get;} public string LastName {set; get;} public …

Read More
Linq select objects in list where exists IN (A,B,C)

I have a list of orders. I want to select orders based on a set of order statuses. So essentially select orders where order.StatusCode in ("A", "B", "C") // Filter the orders based on the order status var filteredOrders = from …

Read More
Remove duplicates in the list using linq

I have a class Items with properties (Id, Name, Code, Price). The List of Items is populated with duplicated items. For ex.: 1 Item1 IT00001 $100 2 Item2 IT00002 $200 3 Item3 IT00003 $150 1 Item1 IT00001 $100 3 Item3 IT00003 $150 How to remove the duplicates in the list …

Read More