ADO.NET Data Services URI Options

Table A-8. ADO.NET Data Services query string options

Option

Description

Example

expand

Requests set(s) of related entities to be retrieved.

/Products(7)?$expand=Categories

orderby

Indicates the sequence entities to be retrieved.

/Employees?$orderby=LastName asc,FirstName asc

skip

Skips a number of data items. Useful for paging.

/Products?$skip=10

top

At most, returns the top number of data items.

/Products?$orderby=ProductName&$top=10

filter

Applies a filtering condition to narrow the data returned.

/Products?$filter='ProductName eq Widget'

Get Data-Driven Services with Silverlight 2 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.