ObjectQuery<T>.Skip Method (String, String, ObjectParameter[])
.NET Framework (current version)
Orders the query results by the specified criteria and skips a specified number of results.
Assembly: System.Data.Entity (in System.Data.Entity.dll)
public ObjectQuery<T> Skip( string keys, string count, params ObjectParameter[] parameters )
Parameters
- keys
-
Type:
System.String
The key columns by which to order the results.
- count
-
Type:
System.String
The number of results to skip. This must be either a constant or a parameter reference.
- parameters
-
Type:
System.Data.Objects.ObjectParameter[]
An optional set of query parameters that should be in scope when parsing.
Return Value
Type: System.Data.Objects.ObjectQuery<T>A new ObjectQuery<T> instance that is equivalent to the original instance with both ORDER BY and SKIP applied.
| Exception | Condition |
|---|---|
| ArgumentNullException | Any argument is null. |
| ArgumentException | keys is an empty string. -or- count is an empty string. |
This example gets five Product objects after skipping the first three in the query result, sorted by Product.ListPrice.
using (AdventureWorksEntities context = new AdventureWorksEntities()) { // Define the parameters used to define the "page" of returned data. int skipValue = 3; int limitValue = 5; // Define a query that returns a "page" or the full // Product data using the Skip and Top methods. // When Top() follows Skip(), it acts like the LIMIT statement. ObjectQuery<Product> query = context.Products .Skip("it.ListPrice", "@skip", new ObjectParameter("skip", skipValue)) .Top("@limit", new ObjectParameter("limit", limitValue)); // Iterate through the page of Product items. foreach (Product result in query) Console.WriteLine("ID: {0}; Name: {1}", result.ProductID, result.Name); }
.NET Framework
Available since 3.5
Available since 3.5
Show: