9.21.2012

LINQ vs SQL Keywords

Difference between LINQ and SQL Keywords
C# LINQ
VB LINQ
ANSI SQL
let
Let
AS
Count(), Sum(),…
Aggregate
COUNT, SUM,… with no group
Skip()
Skip
n/a
SkipWhile()
Skip While
n/a
Take()
Take
n/a
TakeWhile()
Take While
n/a
orderby
Order By
ORDER BY
group
Group By
GROUP BY
Distinct()
Distinct
DISTINCT

Note:
Select ,From,Where,Join and Into keywords have the same name in C# LINQ,VB LINQ and ANSI SQL.

Reference:


No comments:

Post a Comment