LINQ Operators

Prev Next

LINQ Operators

LINQ (Language Integrated Query) operators are methods that provide querying capabilities to .NET languages. These operators can be used to filter, project, aggregate, sort, and transform data from various data sources (such as collections, databases, XML documents, and more).

LINQ operators can be categorized into several types based on their functionality:

1. Projection Operators

Select
SelectMany

2. Filtering Operators

Where
OfType

3. Partitioning Operators

Take
Skip
TakeWhile
SkipWhile

4. Ordering(Sorting) Operators

OrderBy
OrderByDescending
ThenBy
ThenByDescending
Reverse

5. Grouping Operators

GroupBy

6. Joining Operators

Join
GroupJoin

7. Set Operators

Distinct
Union
Intersect
Except
Concat
Zip

8. Element Operators

First
FirstOrDefault
Single
SingleOrDefault
Last
LastOrDefault
ElementAt
ElementAtOrDefault

9. Quantifiers Operators

Any
All
Contains
Count

10. Aggregation Operators

Sum
Average
Min
Max
Aggregate