How to LINQ? Part-4: Standard Query Operators

Having covered the query expressions, we need to look in to query operators. The standard query operators are the methods that form query pattern.  Note that these methods operate on any object whose type implements the IEnumerable<T> or IQueryable<T> interfaces.


The methods that make up these standard query operators are implemented as Extension Methods. To understand this, some knowledge on Extension Methods introduced by C# are required. Refer msdn for more details.


Here is the summary of the LINQ query operators:


  1. Aggregation: Average, Count, LongCount, Max, Min, Sum
  2. Concatenation : Concat
  3. Conversion: Cast, OfType, ToArray, ToDictionary, ToList, ToLookup, ToSequence
  4. Element :  DefaultIfEmpty, ElementAt,  ElementAtOrDefault, First, FirstOrDefault, Last, LastOrDefault, Single, SingleOrDefault
  5. Equality : SequenceEqual
  6. Generation : Empty, Range, Repeat
  7. Grouping : GroupBy
  8. Joining : GroupJoin, Join
  9. Ordering:  OrderBy, ThenBy, OrderByDescending, ThenByDescending, Reverse
  10. Partitioning : Skip, SkipWhile, Take, TakeWhile
  11. Quantifiers:  All, Any, Contains
  12. Restriction : Where
  13. Projection: Select, SelectMany
  14. Set:  Distinct, Except, Intersect, Union

For the detailed information on this topic you can look at this msdn resource. The links below will help you to navigate to each set of operations directly.

Sorting | Set  | Filtering | Quantifier | Projection | Partitioning | Join | Grouping | Generation | Equality | Element | Conversion | Concatenation  |Aggregation


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s