OrderField

This class defines the sort order of results returned by fetch operations (Query, QueryAll, BatchQuery).

Creating an Instance

var orderBy = new OrderField("Id", Order.Ascending);

Or descending.

var orderfield = new OrderField("Id", Order.Descending);

Ascending Method

var field = OrderField.Ascending<Customer>(c => c.Id);

Descending Method

var fields = OrderField.Descending<Customer>(c => c.Id);

Parse Expression

var field = OrderField.Parse<Person>(e => e.Id, Order.Ascending);

Or descending.

var field = OrderField.Parse<Person>(e => e.Id, Order.Descending);

Parse Object

var fields = OrderField.Parse(new
{
    Id = Order.Ascending
});

Or with multiple columns.

var fields = OrderField.Parse(new
{
    LastName = Order.Ascending,
    FirstName = Order.Descending
});

Usability

Pass it to fetch operations.

var orderBy = new OrderField("Id", Order.Ascending);
using (var connection = new SqlConnection(connectionString0))
{
    var people = connection.QueryAll<Person>(orderBy: orderBy);
}