.NET Course
  • Welcome developers
  • LINQ
    • Advanced c# overview
      • Implicit typing
      • Generics
      • Attributes
      • Reflection
      • Delegates
      • Anonymous Methods and Lambda Expressions
      • Events
      • Anonymous Types
      • Ref vs Out
      • Task
      • TaskFactory
      • Asynchronous programming with async and await
      • Abstract class VS Interface
      • Inheritance, Composition and Aggregation in C#
    • LINQ Tutorial
      • Loading Related Entities
      • Lambda Expression
      • Standard Query Operators
    • Testing ASP.NET Core
      • Implementing unit tests for ASP.NET Core Web APIs
    • Software development principles
      • Object-Oriented Programming (Principles)
      • N-tier architecture style
      • Command and Query Responsibility Segregation (CQRS) pattern
      • SOLID: The First 5 Principles of Object Oriented Design
  • Helping links
    • SonarQube installation and tutorial for .net core projects
  • C# .NET Interview Questions
    • Ultimate C# Interview questions
      • Part 4
      • Part 3
      • Part 2
      • Part 1
  • Unit test .NET Core xUnit & MOQ
    • Content
      • Snippets
      • Traits
Powered by GitBook
On this page

Was this helpful?

  1. LINQ
  2. LINQ Tutorial

Standard Query Operators

Standard Query Operators in LINQ are actually extension methods for the IEnumerable<T> and IQueryable<T> types. They are defined in the System.Linq.Enumerable and System.Linq.Queryable classes. There are over 50 standard query operators available in LINQ that provide different functionalities like filtering, sorting, grouping, aggregation, concatenation, etc.

Classification

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, Min, Sum

Quantifiers

All, Any, Contains

Elements

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

Set

Distinct, Except, Intersect, Union

Partitioning

Skip, SkipWhile, Take, TakeWhile

Concatenation

Concat

Equality

SequenceEqual

Generation

DefaultEmpty, Empty, Range, Repeat

Conversion

AsEnumerable, AsQueryable, Cast, ToArray, ToDictionary, ToList

PreviousLambda ExpressionNextTesting ASP.NET Core

Last updated 3 years ago

Was this helpful?