ADO.Net DataServices QueryString parameters

With ADO.Net Data Service you can add parameters in the Querystring. The following parameters are recognized:

• expand 
• orderby 
• skip 
• top 
• filter

So if your request for all products was AdventureWorks.svc/Product you can add parameters like this AdventureWorks.svc/Product?$[paramatername]=expression

For the examples I use the Product table of the Adventureworks database.

Filter

Filter allows you to filter the selected result based on a expression. The expression has two types of operators: logical, and arithmetic.

The logical operators are:

• eq  (==) 
• ne  (!=)
• gt  (<)
• gteq  (<=)
• lt  (>)
• lteq  (>=)
• and  (&&)
• or  (||)
• not  (!)

The arithmetic operators are:

• add  (Addition)
• sub  (Subtraction)
• mul (Multiplication)
• div  (Division)
• mod  (Modulus)

Example
Let's say I want to have the product with the value 534 in the ProductId column.

Result

Expand

Example
Let's say we want to use the ProductReviews of the product in our application. To do this we need to load the ProductReviews values on request, we can achieve this with the expand paramater.

To get a clear view of what the expand parameter does I included the filter funtion on ProductId 534 so we can compare the results.

Result

Skip

Example all productreviews

Result
 

Example skip productreviews

Result
Only the last two ProductReview objects get returned.
 

Top

Example

Result
This will return the first three product reviews.

Orderby

Example

Result
This will sort the results by the column 'Name'.

You can also define build a more complex order clause by combining columns in a comma-delimited list, example:

Result
Only the product with ProductID values equeals 534 will be returned.

Combining attributes

You can combine the attributes. You can do this by creating a URL and seperating the attibutes with a '&', example;
AdventureWorks.svc/Product?$[paramatername]=expression&[paramatername]=expression

Example