Visual Basic 2015 Unleashed

Using SQL Syntax Against Entities

LINQ to SQL also allows writing SQL code against entities so that you can still take advantage of the object model if you prefer the old-fashioned way of manipulating data. The DataContext class offers an instance method named ExecuteQuery(Of T) that allows sending SQL instructions in string form. For example, the following code retrieves a list of products for the Grain/Cereals category, ordered by product name:

Click here to view code image

Sub DirectSqlDemo()    Dim products = northwind.        ExecuteQuery(Of Product)("SELECT * FROM PRODUCTS WHERE " & _                                 "CATEGORYID='5' ORDER BY PRODUCTNAME")    For Each prod In products        Console.WriteLine(prod.ProductName)    NextEnd ...