ObjectQuery<T>.Where(String, ObjectParameter[]) ObjectQuery<T>.Where(String, ObjectParameter[]) ObjectQuery<T>.Where(String, ObjectParameter[]) ObjectQuery<T>.Where(String, ObjectParameter[]) Method

Definición

Limita la consulta a los resultados que coinciden con los criterios de filtrado especificados.Limits the query to results that match specified filtering criteria.

public:
 System::Data::Objects::ObjectQuery<T> ^ Where(System::String ^ predicate, ... cli::array <System::Data::Objects::ObjectParameter ^> ^ parameters);
public System.Data.Objects.ObjectQuery<T> Where (string predicate, params System.Data.Objects.ObjectParameter[] parameters);
member this.Where : string * System.Data.Objects.ObjectParameter[] -> System.Data.Objects.ObjectQuery<'T>
Public Function Where (predicate As String, ParamArray parameters As ObjectParameter()) As ObjectQuery(Of T)

Parámetros

predicate
String String String String

Predicado de filtro.The filter predicate.

parameters
ObjectParameter[]

Cero o más parámetros que se usan en este método.Zero or more parameters that are used in this method.

Devoluciones

Nueva instancia de ObjectQuery<T> que es equivalente a la instancia original, pero aplicando WHERE.A new ObjectQuery<T> instance that is equivalent to the original instance with WHERE applied.

Excepciones

predicate es null.predicate is null.

O bien-or- parameters es null.parameters is null.

predicate es una cadena vacía.The predicate is an empty string.

Ejemplos

En este ejemplo se basa en el modelo AdventureWorks Sales.This example is based on the AdventureWorks Sales Model. El ejemplo crea un nuevo ObjectQuery<T> que contiene los resultados de la consulta existente filtrados por los siguientes criterios: "it.ProductID = 900".The example creates a new ObjectQuery<T> that contains results of the existing query filtered by the following criteria: "it.ProductID = 900".

int productID = 900;
using (AdventureWorksEntities context =
    new AdventureWorksEntities())
{
    string queryString =
        @"SELECT VALUE product FROM 
            AdventureWorksEntities.Products AS product";

    ObjectQuery<Product> productQuery1 =
        new ObjectQuery<Product>(queryString,
            context, MergeOption.NoTracking);

    ObjectQuery<Product> productQuery2 =
        productQuery1.Where("it.ProductID = @productID");

    productQuery2.Parameters.Add(new ObjectParameter("productID", productID));

    // Iterate through the collection of Product items.
    foreach (Product result in productQuery2)
    {
        Console.WriteLine("Product Name: {0}; Product ID: {1}",
            result.Name, result.ProductID);
    }
}
Dim productID = 900
Using context As New AdventureWorksEntities()
    Dim queryString As String = "SELECT VALUE product FROM AdventureWorksEntities.Products AS product"

    Dim productQuery1 As New ObjectQuery(Of Product)(queryString, context, MergeOption.NoTracking)

    Dim productQuery2 As ObjectQuery(Of Product) = productQuery1.Where("it.ProductID = @productID")
    productQuery2.Parameters.Add(New ObjectParameter("productID", productID))

    ' Iterate through the collection of Product items. 
    For Each result As Product In productQuery2
        Console.WriteLine("Product Name: {0}; Product ID: {1}", result.Name, result.ProductID)
    Next
End Using

Se aplica a

Consulte también: