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