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

Definition

Namespace:

System.Data.Objects

Assembly:

System.Data.Entity.dll

Orders the query results by the specified criteria.

C#

public System.Data.Objects.ObjectQuery<T> OrderBy(string keys, params System.Data.Objects.ObjectParameter[] parameters);

Parameters

keys

String

The key columns by which to order the results.

parameters

ObjectParameter[]

Zero or more parameters that are used in this method.

Returns

ObjectQuery<T>

A new ObjectQuery<T> instance that is equivalent to the original instance with ORDER BY applied.

Exceptions

ArgumentNullException

The keys or parameters parameter is null.

ArgumentException

keys is an empty string.

Examples

This example creates a new ObjectQuery<T> object that contains the results of the existing query order by ProductID.

C#

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.OrderBy("it.ProductID");

    // Iterate through the collection of Product items.
    foreach (Product result in productQuery2)
    {
        Console.WriteLine("{0}", result.ProductID);
    }
}

Remarks

The ordering of results in a nested query cannot be guaranteed.

OrderBy should always be the final query builder method in the sequence.

Applies to

See also

• Querying Data as Objects (Entity Framework)