Export (0) Print
Expand All

ObjectQuery(T).Where Method

Limits the query to results that match specified filtering criteria.

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

member Where : 
        predicate:string * 
        parameters:ObjectParameter[] -> ObjectQuery<'T> 


Type: System.String

The filter predicate.

Type: System.Data.Objects.ObjectParameter[]

Zero or more parameters that are used in this method.

Return Value

Type: System.Data.Objects.ObjectQuery(T)
A new ObjectQuery(T) instance that is equivalent to the original instance with WHERE applied.


predicate is a null reference (Nothing in Visual Basic).


parameters is a null reference (Nothing in Visual Basic).


The predicate is an empty string.

This example is based on the Adventure Works Sales Model. The example creates a new ObjectQuery(T) that contains results of the existing query filtered by the following criteria: "it.ProductID = 900".

No code example is currently available or this language may not be supported.

.NET Framework

Supported in: 4.6, 4.5, 4, 3.5 SP1

.NET Framework Client Profile

Supported in: 4
© 2015 Microsoft