ISqlHavingAndOr<TBuilder> Interface
.NET Standard 2.x
Represents an object, that uses AND or OR logical operator and adds a search condition in the HAVING clause of a SQL statement. The return values of all methods are always the current TBuilder object.
Namespace: SnapObjects.Data
Assembly: SnapObjects.Data.dll
Syntax
public interface ISqlHavingAndOr<TBuilder>;
Methods
| Name | Return Type | Description |
|---|---|---|
| AndHaving(string left, ISqlParameter parameter) | TBuilder | Adds the AND logical operator and a search condition to the HAVING clause. Specifies a SQL expression to the left of the operator and a SQL parameter to the right of the operator. The operator is '='. |
| AndHaving(string left, SqlBinaryOperator sqlOperator, ISqlParameter parameter) | TBuilder | Adds the AND logical operator and a search condition to the HAVING clause. Specifies a SQL expression to the left of the operator and a SQL parameter to the right of the operator. |
| AndHaving(string left, string right) | TBuilder | Adds the AND logical operator and a search condition to the HAVING clause. Specifies SQL expressions on both the left and right of the operator. The operator is '='. |
| AndHaving(string left, SqlBinaryOperator sqlOperator, string right) | TBuilder | Adds the AND logical operator and a search condition to the HAVING clause. Specifies SQL expressions on both the left and right of the operator. |
| AndHaving(string left, ISqlBuilder sqlBuilder) | TBuilder | Adds the AND logical operator and a search condition to the HAVING clause. Specifies a SQL expression on the left of the operator and a SQL subquery on the right of the operator. The operator is '='. |
| AndHaving(string left, SqlBinaryOperator sqlOperator, ISqlBuilder sqlBuilder) | TBuilder | Adds the AND logical operator and a search condition to the HAVING clause. Specifies a SQL expression on the left of the operator and a SQL subquery on the right of the operator. |
| AndHaving(ISqlHavingCondition condition) | TBuilder | Adds the AND logical operator and a search condition (specified by an ISqlHavingCondition object) to the HAVING clause. |
| AndHaving(ISqlHavingCondition condition, string alias) | TBuilder | Adds the AND logical operator and a search condition (specified by an ISqlHavingCondition object) to the HAVING clause. You can specify an alias for the search condition. |
| AndHavingRaw(string clause, params ISqlParameter[] parameters) | TBuilder | Adds the AND logical operator and a raw SQL to the HAVING clause. |
| AndHavingRaw(string clause, string alias, params ISqlParameter[] parameters) | TBuilder | Adds the AND logical operator and a raw SQL string to the HAVING clause. You need to specify an alias for the raw SQL. |
| AndHavingValue(string left, object value) | TBuilder | Adds the AND logical operator and a search condition to the HAVING clause. Specifies a SQL expression on the left the operator and a specific value on the right of the operator. The operator is '='. |
| AndHavingValue(string left, SqlBinaryOperator sqlOperator, object value) | TBuilder | Adds the AND logical operator and a search condition to the HAVING clause. Specifies a SQL expression on the left the operator and a specific value on the right of the operator. |
| OrHaving(string left, ISqlParameter parameter) | TBuilder | Adds the OR logical operator and a search condition to the HAVING clause. Specifies a SQL expression on the left of the operator and a SQL parameter on the right of the operator. The operator is '='. |
| OrHaving(string left, SqlBinaryOperator sqlOperator, ISqlParameter parameter) | TBuilder | Adds the OR logical operator and a search condition to the HAVING clause. Specifies a SQL expression to the left of the operator and a SQL parameter to the right of the operator. |
| OrHaving(string left, string right) | TBuilder | Adds the OR logical operator and a search condition to the HAVING clause. Specifies SQL expressions on both the left and right of the operator. The operator is '='. |
| OrHaving(string left, SqlBinaryOperator sqlOperator, string right) | TBuilder | Adds the OR logical operator and a search condition to the HAVING clause. Specifies SQL expressions on both the left and right of the operator. |
| OrHaving(string left, ISqlBuilder sqlBuilder) | TBuilder | Adds the OR logical operator and a search condition to the HAVING clause. Specifies a SQL expression on the left of the operator and a SQL subquery on the right of the operator. The operator is '='. |
| OrHaving(string left, SqlBinaryOperator sqlOperator, ISqlBuilder sqlBuilder) | TBuilder | Adds the OR logical operator and a search condition to the HAVING clause. Specifies a SQL expression on the left of the operator and a SQL subquery on the right of the operator. |
| OrHaving(ISqlHavingCondition condition) | TBuilder | Adds the OR logical operator and a search condition (specified by an ISqlHavingCondition object) to the HAVING clause. |
| OrHaving(ISqlHavingCondition condition, string alias) | TBuilder | Adds the OR logical operator and a search condition (specified by an ISqlHavingCondition object) to the HAVING clause. You can specify an alias for the search condition. |
| OrHavingRaw(string clause, params ISqlParameter[] parameters) | TBuilder | Adds the OR logical operator and a raw SQL to the HAVING clause. |
| OrHavingRaw(string clause, string alias, params ISqlParameter[] parameters) | TBuilder | Adds the OR logical operator and a raw SQL to the HAVING clause. You need to specify an alias for the raw SQL. |
| OrHavingValue(string left, object value) | TBuilder | Adds the OR logical operator and a search condition to the HAVING clause. Specifies the SQL expression on the left the operator and a specific value on the right of the operator. The operator is '='. |
| OrHavingValue(string left, SqlBinaryOperator sqlOperator, object value) | TBuilder | Adds the OR logical operator and a search condition to the HAVING clause. Specifies a SQL expression on the left the operator and a specific value on the right of the operator. |
Remarks
AND logical operator: Combines two conditions and evaluates to TRUE when both of the conditions are TRUE.
OR logical operator: Combines two conditions and evaluates to TRUE when either condition is TRUE.