VS 2008 SP1 +. NET 3.5 SP1 (6)

Entity SQL for the Entity Framework (Entity Framework)

Introduced

Sample database with Northwind, ado.net Entity framework Entity SQL

eSQL can also be used on LINQ methods

Query expression

Select, from, where, order by, group BY, have
Cross join, inner join, left outer join, right outer join, full outer Join case If
then else end

Collection operators

Anyelement (expression)-extracts any element from the collection

Except-Deletes the same item from the result of the left expression as the result of the right expression and returns the result

Flatten (collection)-Converts a collection of multiple collections into a collection

Intersect-Returns the same entry for the query result on both sides of the operator

[NOT] exists (expression)-Determines whether the query results exist

[NOT] in {,}-determine if a value is in a collection

Overlaps-Determines whether the query results on both sides of the operator have the same item

Set (expression)-Remove duplicates

Union-joins the query results on both sides of the operator into a single collection (remove Duplicates)

UNION All-Joins the query results on both sides of the operator into a single collection (including duplicates)

Top (N)-Take the first N records

Paging operators

Skip N-The number of items that need to be skipped, combined with order by

Limit N-The number of items that need to be selected, combined with order by