Symphony Framework
WheredBConditions Enumeration
Example Example 
Symphony.dB Namespace : WheredBConditions Enumeration
Enumeration defining the available where clause conditions avaialbe when using the DBAccess.Select method.
public enum WheredBConditions : System.Enum 
Contains The value is contained within the column.
CustomExpression Provide a custom expresions. This condition should be used with caution as it could provide the ability to inject invalid SQL syntax into the database query.
EqualTo The value matches the column data.
GreatThan The value is greater than the column data.
GreatThanOrEqualTo The value is greater than or equal to the column data.
LessThan The value is less than the value in the column data.
LessThanOrEqualTo The value is less than or equal to the value in the column data.
NotEqualTo The column data is no equal to the comparison value.
StartsWith The column data starts with the value being tested.
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))

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


Symphony.dB Namespace