ISSqlWhereBuilder Class

A utility class to assist building an SQL WHERE clause.

By default, appending to the SQL WHERE clause will cause an AND to be added between tests. Use the BlockBegin and BlockEnd methods to change this behaviour and to create nested blocks.

Methods

Name Description
Append Append to the SQL Where clause.
AppendComparisonBoolean Append a Boolean comparison to the SQL Where clause.
AppendComparisonDate Append a Date comparison to the SQL Where clause.
AppendComparisonDateLocalToUtc Append a UTC Date comparison to the SQL Where clause. The date is converted to UTC dates before the date is appended to the SQL Where clause.
AppendComparisonDateTime Append a Date/Time comparison to the SQL Where clause.
AppendComparisonDecimal Append a Decimal comparison to the SQL Where clause.
AppendComparisonDouble Append a Double comparison to the SQL Where clause.
AppendComparisonField Append a field comparison to the SQL Where clause.
AppendComparisonInteger Append an Integer comparison to the SQL Where clause.
AppendComparisonIntegerBoolean Append a Boolean comparison to the SQL Where clause where the field on the database is actually an Integer.
AppendComparisonLong Append an Long comparison to the SQL Where clause.
AppendComparisonNotNull Append a field comparison for Not Null to the SQL Where clause.
AppendComparisonNull Append a field comparison for Null to the SQL Where clause.
AppendComparisonSoundEx Append a string SoundEx comparison to the SQL Where clause.
AppendComparisonString Append a string comparison to the SQL Where clause.
AppendComparisonStringWithPk Append a Range to the SQL Where clause where the Range does not apply to a field in the current table but a field in another table where the main table just holds the primary key.
AppendDateRange Append a Date Range condition to the SQL Where clause.
AppendDateRangeLocalToUtc Append a UTC Date Range to the SQL Where clause. The 'dateRange' parameter is in Local time. The dates are converted to UTC dates before the date range is appended to the SQL Where clause.
AppendEnumRange Append a Range consisting of a comma separated list of Enum text representations to the SQL Where clause.
AppendEnumRangeUsingStringConverter Append a Range consisting of a comma separated list of Enum text representations to the SQL Where clause.
AppendExists Append an EXISTS sub-query to the SQL Where clause.
AppendFunctionBoolean Append a function comparison to a Boolean value in the SQL Where clause.
AppendFunctionDate Append a function comparison to a Date value in the SQL Where clause.
AppendFunctionDecimal Append a function comparison to a Decimal value in the SQL Where clause.
AppendFunctionDouble Append a function comparison to a Double value in the SQL Where clause.
AppendFunctionField Append a function comparison to a Field in the SQL Where clause.
AppendFunctionInteger Append a function comparison to an Integer value in the SQL Where clause.
AppendFunctionString Append a function comparison to an String value in the SQL Where clause.
AppendIn Append an "In" clause to the SQL Where.
AppendInSubQuery Append an "In" where clause to the SQL Where.
AppendNotExists Append a NOT EXISTS sub-query to the SQL Where clause.
AppendNumberRange Append a Number Range condition to the SQL Where clause.
AppendPkFromId Appends a Primary Key to the SQL Where clause based upon the Id of a Foreign table.
AppendRange Append a Range to the SQL Where clause.
AppendRangeWithPk Append a Range to the SQL Where clause where the Range does not apply to a field in the current table but a field in another table where the main table just holds the primary key.
BlockBegin Begin a nested block.
BlockBeginAnd Begin an 'AND' nested block.
BlockBeginOr Begin an 'OR' nested block.
BlockEnd End a nested block.
Clear Clear the builder.

Properties

Name Description
SqlWhere The SQL Where clause.
Namespace:
Intersoft.ISSupport6
Assembly:
ISSupport6, Version=6.0.3
Target Framework:
.NET 9.0