Query Operatoren (Query Operators) und SQL-Befehle (SQL-Commands)

Query Operator > SQL-Befehl
---------------------------
Aggregate > (Exception)
All > WHERE
Any > WHERE IN
AsEnumerable >
AsQueryable >
Average > AVG
Cast >
Concat > UNION ALL
Contains > WHERE IN
Count > COUNT
DefaultIfEmpty >
Distinct > SELECT DISTINCT
ElementAt >
ElementAtOrDefault >
Empty >
Except > WHERE NOT IN
First >
FirstOrDefault > SELECT TOP 1 ORDER BY
GroupBy > GROUP BY
GroupJoin > LEFT OUTER JOIN
GroupJoin > RIGHT OUTER JOIN
Intersect > WHERE IN
Join > INNER JOIN
Last >
LastOrDefault > SELECT TOP 1 ORDER BY DESC
Like >
LongCount > COUNT
Max > MAX
Min > MIN
OrderBy > ORDER BY
OrderByDescending > ORDER BY DESC
Range >
Repeat >
Reverse > (Exception)
Select > SELECT
SelectMany > CROSS JOIN
SelectMany > INNER JOIN
SelectMany > LEFT OUTER JOIN
SequenceEqual >
Single >
SingleOrDefault >
Skip > NOT IN
SkipWhile > (Exception)
Sum > SUM
Take > TOP n
TakeWhile > (Exception)
ThenBy > ORDER BY
ThenByDescending > ORDER BY DESC
ToArray >
ToDictionary >
ToList >
ToLookup >
Union > UNION
Where > WHERE

Query Operatoren

Die Query-Operatoren lassen sich grob in die folgenden Kategorien gliedern.

Restriktionsoperator
Where

Projektionsoperatoren
Select
SelectMany

Aufteilungsoperatoren
Skip
SkipWhile
Take
TakeWhile

Join-Operatoren
GroupJoin
Join

Konkatinierungsoperator
Concat

Sortieroperatoren
OrderBy (descending)
ThenBy (descending)
Reverse

Gruppierungsoperatoren
GroupBy

Set-Operatoren
Set
Distinct
Except
Intersect
Union

Konvertierungsoperatoren
AsEnumerable
AsQueryable
Cast
ToArray
ToDictionary
ToList
ToLookup

Vergleichsoperatoren
SequenceEqual

Elementoperatoren
ElementAt
ElementAtOrDefault
First
FirstOrDefault
Last
LastOrDefault
Single
SingleOrDefault
DefaultIfEmpty

Generierungsoperatoren
Empty
Range
Repeat

Quantifizierungsoperatoren
All
Any
Contains

Aggregatoperatoren
Aggregate
Average
Count
LongCount
Max
Min
Sum

Andere
Like (StartWith)