OrderBydB Class

Class to allow the definition of the order by clause for the DBAccess.Select methods.

Syntax

public class OrderBydB

Example

This example shows how to create and instance of the OrderBydB class and use it with the Select method.

Symphony.dB.DBAccess itemAccess = new DBAccess("ITEM", "DATABASE:DatabaseManager");
OrderBydB sequence = new OrderBydB();
sequence.Add("item_quantity");
foreach (string item in itemAccess.Select(sequence))
{

}

This exmaples uses an OrderBy instance to deterime the order of the rows returned from the databsae. Only the selected column/fields are returned.

Symphony.dB.DBAccess PartAccess = new DBAccess("PART", "DATABASE:DatabaseManager");
OrderBydB partOrder = new OrderBydB();
partOrder.Add("part_code", OrderBydBDirections.Desc);
foreach (string part in PartAccess.Select("part_code, part_description", partOrder))
{

}

Inheritance Hierarchy

System.Object
Symphony.dB.OrderBydB

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

OrderBydB Members
Symphony.dB Namespace