WheredBConditions Enumeration

Enumeration defining the available where clause conditions avaialbe when using the DBAccess.Select method.

Syntax

public enum WheredBConditions : System.Enum

Members

Member	Description
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.

Example

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

System.Object
   System.ValueType
      System.Enum
         Symphony.dB.WheredBConditions

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

Symphony.dB Namespace