Symphony Framework
OrderBydB Class
Members  Example 
Symphony.dB Namespace : OrderBydB Class
Class to allow the definition of the order by clause for the DBAccess.Select methods.
public class OrderBydB 
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();
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



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

See Also


OrderBydB Members
Symphony.dB Namespace