In this tutorial, we will learn about LINQ 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.
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.