ObjectQuery<T>.OrderBy Method
Orders the query results by the specified criteria.
Assembly: System.Data.Entity (in System.Data.Entity.dll)
Parameters
- keys
- Type: System.String
The key columns by which to order the results.
- parameters
- 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 ORDER BY applied.
| Exception | Condition |
|---|---|
| ArgumentNullException | The keys or parameters parameter is null. |
| ArgumentException | The key is an empty string. |
This example is based on the Adventure Works Sales Model. The example creates a new ObjectQuery<T> object that contains the results of the existing query order by ProductID.
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); } }
Windows 8, Windows Server 2012, Windows 7, Windows Vista SP2, Windows Server 2008 (Server Core Role not supported), Windows Server 2008 R2 (Server Core Role supported with SP1 or later; Itanium not supported)
The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.
