Results projection, paging and ordering

Simple.OData.Client supports all stanard OData query modifiers that can be used to control number of rows and columns fetched during the request execution.

---

Retrieve ProductID for all products

var products = client
    .For("Products")
    .Select("ProductID")
    .FindEntries();
Assert.True(products.First()["ProductID"] > 0);
Assert.False(products.First().ContainsKey("ProductName"));

Request URI: GET Products?$select=ProductID

---

Retrieve only the first row from the Products collection

var products = client
    .For("Products")
    .Top(1)
    .FindEntries();
Assert.Equal(1, products.Count());

Request URI: GET Products?$top=1

---

Retrieve all except the first row from the Products collection

var products = client
    .For("Products")
    .Skip(1)
    .FindEntries();
Assert.Equal(76, products.Count());

Request URI: GET Products?$skip=1

---

Skip two and retrieve one row from the Products collection

var products = client
    .For("Products")
    .Skip(2)
    .Top(1)
    .FindEntries();
Assert.Equal(1, products.Count());

Request URI: GET Products?$skip=2&$top=1

---

Retrieve all products ordered by product name

var products = client
    .For("Products")
    .OrderBy("ProductName")
    .FindEntries();
Assert.Equal("Alice Mutton", products.First()["ProductName"]);

Request URI: GET Products?$orderby=ProductName

---

Retrieve all products ordered descending by product name

var products = client
    .For("Products")
    .OrderByDescending("ProductName")
    .FindEntries();
Assert.Equal("Zaanse koeken", products.First()["ProductName"]);

Request URI: GET Products?$orderby=ProductName%20desc

---

Retrieve product names in descending order

var products = client
    .For("Products")
    .OrderByDescending("ProductName")
    .Select("ProductName")
    .FindEntries();
Assert.Equal("Zaanse koeken", products.First()["ProductName"]);

Request URI: GET Products?$orderby=ProductName%20desc&$select=ProductName

---

See also:
Retrieving data