As I’ve said, the syntax of Entity SQL is almost identical to standard SQL. It supports all the clauses you’d expect, including
ORDER BY. (For a complete list, check MSDN for “Entity SQL Reference”.) But there’s an important difference in the
SELECT clause, which determines what kind of results the query returns:
SELECT clause, used without the
VALUE keyword, can return one or more values, each of which must be given an alias with the
AS keyword. But rather than returning the objects directly,
SELECT wraps them in a
DbDataRecord that you access using classic ADO.NET techniques.