Symphony Framework
Select(WheredB) Method
Example 
Symphony.dB Namespace > DBAccess Class > Select Method : Select(WheredB) Method
A WheredB instance the defines selection criteria.
The select method allows you to query the file and return the selected records in the file.
Syntax
public ArrayList Select( 
   WheredB whereObject
)

Parameters

whereObject
A WheredB instance the defines selection criteria.

Return Value

An ArrayList of records from the data file.
Remarks
The WheredB object defines the clause to use when selecting the rquried rows from the database table.
Example
This example demonstrates how to apply a where caluse to a select to filter the results from the database.
Symphony.dB.DBAccess itemAccess = new DBAccess("ITEM", "DATABASE:DatabaseManager");
WheredB clause = new WheredB();
clause.Add("part_description", WheredBConditions.Contains, "GOLD");
foreach (string item in itemAccess.Select(clause))
{

}
This example filters the results from the database and limits the column/fields returned.
Symphony.dB.DBAccess PartAccess = new DBAccess("PART", "DATABASE:DatabaseManager");
WheredB fieldClause = new WheredB();
fieldClause.Add("part_description", WheredBConditions.Contains, "GOLD");
foreach (string part in PartAccess.Select("part_code, part_description", fieldClause))
{

}
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

See Also

Reference

DBAccess Class
DBAccess Members
Overload List