Query operators in Linq

Different types of standard query operators

Operator Type

Operator Name

Aggregate

Aggregate, Average, Count, LongCount, Max, Min, Sum

Concatenation

Concat

Conversions

Cast, OfType, ToList, ToArray, ToLookup, ToDictionary, AsEnumerable

Element

Single, SingleOrDefault, First, FirstOrDefault, Last, LastOrDefault, ElementAt, ElementAtOrDefault

Equality

SequenceEqual

Generation

Repeat, Range, Empty

Grouping

GroupBy

Join

Join, GroupJoin

Ordering

OrderBy, OrderByDescending, ThenBy, ThenByDescending, Reverse

Partitioning

Skip, SkipWhile, Take, TakeWhile

Projection

Select, SelectMany

Quantifier

Contains, All, Any

Restriction

Where

Set

Union, Intersect, Except, Distinct