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