Entity SQL

http://blogs.msdn.com/b/adonet/archive/2007/05/30/entitysql.aspx

SQL is the time proven query language for data access. However, since EDM introduces an enhanced data model which builds on entities, rich types and relationships, we need a query language that enables programmers to reason, express and write queries in terms of EDM abstractions. EntitySQL was designed to address this need.

Sample 1: (please note the database has table call "Production.ProductCategory",but here we are using "ProductCategories"

 using(AdventureWorksEntities ent=new AdventureWorksEntities())
            {
                var parameter = new ObjectParameter("Name",  "Bikes%");
                var result = ent.CreateQuery<string>(
                "SELECT VALUE (c.Name) from ProductCategories AS c WHERE c.Name LIKE @Name", parameter);
                foreach (var VARIABLE in result)
                {
                    Response.Write(VARIABLE);
                }
            }

Sample 2: Pagination

SELECT VALUE product
FROM AdventureWorksEntities.Products AS product
ORDER BY product.ListPrice
SKIP @skip LIMIT @limit