LINQ Standard Query Operators

In this tutorial, we will learn about LINQ standard query operators.

Standard Query Operators

The Standard Query Operators are nothing but a set of extension methods that are used to write the LINQ Query. Most of these methods provide us a useful features to operate on collections, where a collection is an object whose type implements the IEnumerable<T> interface or the IQueryable<T> interface. Some of the features of the standard query operators such as filtering, projection, aggregation, sorting, and more. 

Different Types of Standard Query Operator

Standard Query Operators can be categorized based on the functionality they provide. The Standard Query Operators  are divided into the following categories as given below:

Category Standard Query Operators
Filtering Where, OfType
Sorting OrderBy, OrderByDescending, ThenBy, ThenByDescending, Reverse
Grouping GroupBy, ToLookup
Join GroupJoin, Join
Projection Select, SelectMany
Aggregation Aggregate, Average, Count, LongCount, Max, MaxBy, Min, MinBy, Sum
Quantifiers All, Any, Contains
Elements ElementAt, ElementAtOrDefault, First, FirstOrDefault, Last, LastOrDefault, Single, SingleOrDefault
Set Distinct, DistinctBy, Except, ExceptBy, Intersect, IntersectBy, Union, UnionBy
Partitioning Skip, SkipWhile, SkipLast, Take, TakeWhile, TakeLast, Chunk
Concatenation Concat
Equality SequenceEqual
Generation DefaultEmpty, Empty, Range, Repeat
Conversion AsEnumerable, AsQueryable, Cast, ToArray, ToDictionary, ToList

Learn Filtering Operator - Where in the next tutorial.