May 2010
Intermediate to advanced
1272 pages
61h 18m
English
LINQ to Entities is not the only way to query data exposed by EDMs. An important alternative named Entity SQL allows querying entity data models providing both the ability to send SQL instructions to the data source and to treat query results as managed entities. To accomplish this, the ObjectContext class exposes a method named CreateQuery(Of T) that queries the EDM via the specified set of SQL instructions. The following example shows how you can retrieve a list of products for the Grains/Cereals category in Northwind, sorting the result by the product name:

CreateQuery(Of T) returns an ObjectQuery(Of T) that ...
Read now
Unlock full access