LINQ Filtering
Where( x => x.id == id)
LINQ Join
Join, GroupJoin
LINQ Join syntax
OuterData.Join(InnerData, o => o.key, i => i.key, (o,i) => result)
LINQ Projection
Select: essential a transformation on the data
DATA.Select(d => d.func());
LINQ Sorting
OrderBy, OrderByDescending, ThenBy,ThenByDescending, Reverse
LINQ Group
GroupBy: can perform transformations on the data added to the group