ObjectContext.CreateQuery(Of T) Method (String, ObjectParameter())

 

Creates an ObjectQuery(Of T) in the current object context by using the specified query string.

Namespace:   System.Data.Objects
Assembly:  System.Data.Entity (in System.Data.Entity.dll)

Public Function CreateQuery(Of T) (
	queryString As String,
	ParamArray parameters As ObjectParameter()
) As ObjectQuery(Of T)

Parameters

queryString
Type: System.String

The query string to be executed.

parameters
Type: System.Data.Objects.ObjectParameter()

Parameters to pass to the query.

Return Value

Type: System.Data.Objects.ObjectQuery(Of T)

An ObjectQuery(Of T) of the specified type.

Type Parameters

T

The entity type of the returned ObjectQuery(Of T).

Exception Condition
ArgumentNullException

The queryString or parameters parameter is null.

Use CreateQuery(Of T) to create an ObjectQuery(Of T) of the specified type that belongs to the current object context.

This example is based on the AdventureWorks Sales Model.

The example creates a simple query and iterates through the collection of results.

Using context As New AdventureWorksEntities()
    Dim queryString As String = "SELECT VALUE contact FROM AdventureWorksEntities.Contacts " & _
            " AS contact WHERE contact.FirstName = @fn"

    Dim contactQuery As ObjectQuery(Of Contact) = context.CreateQuery(Of Contact)(queryString, New ObjectParameter("fn", "Frances"))

    ' Iterate through the collection of Contact items. 
    For Each result As Contact In contactQuery
        Console.WriteLine("First Name: {0}, Last Name: {1}", result.FirstName, result.LastName)
    Next
End Using

.NET Framework
Available since 3.5
Return to top
Show: