Querying EDMs with Entity SQL

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 ...

Get Visual Basic® 2010 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.