Interface IOperatorCondition

Represents details on how to join IQueryBuilders.

Namespace: LemonEdge.DataAccess.Core.Abstractions.Builders
Assembly: LemonEdge.DataAccess.Core.Abstractions.dll
Syntax
public interface IOperatorCondition

Properties

Aggregate1

The type of the first AggregateFunction.

Declaration
AggregateFunction Aggregate1 { get; set; }
Property Value
Type Description
AggregateFunction

Aggregate2

The type of the second AggregateFunction.

Declaration
AggregateFunction Aggregate2 { get; set; }
Property Value
Type Description
AggregateFunction

BeginGroup

Whether this condition is the starting condition.

Declaration
bool BeginGroup { get; set; }
Property Value
Type Description
bool

Column1

The aggregation column, if Aggregate1 is not None.

Declaration
string Column1 { get; set; }
Property Value
Type Description
string

Column2

The aggregation column, if Aggregate2 is not None.

Declaration
string Column2 { get; set; }
Property Value
Type Description
string

Comment

A comment for the SQL Condition.

Declaration
string Comment { get; set; }
Property Value
Type Description
string

ComparativeExpression

Instead of comparing TableAlias1.Column1 to TablesAlias2.Column2, this holds an expression resulting in TableAlias1.Column1 being compared to ComparativeExpression.

Declaration
string ComparativeExpression { get; set; }
Property Value
Type Description
string

ComparativeExpressionIsNull

Indicates if the ComparativeExpression is just the value null.

Declaration
bool ComparativeExpressionIsNull { get; set; }
Property Value
Type Description
bool

EndGroup

Whether this condition is the ending condition.

Declaration
bool EndGroup { get; set; }
Property Value
Type Description
bool

GroupType

The grouping type for this Condition.

Declaration
GroupType GroupType { get; set; }
Property Value
Type Description
GroupType

IsNull

Declaration
bool IsNull { get; set; }
Property Value
Type Description
bool

NullValue

An optional Null value to be provided for TableAlias1.Column1, creating the statement IsNull(TableAlias1.Column1, NullValue)

Declaration
string NullValue { get; set; }
Property Value
Type Description
string

Operator

The SQL Operation to perform as a comparison.

Declaration
SQLOperator Operator { get; set; }
Property Value
Type Description
SQLOperator

TableAlias1

The alias to give the first table.

Declaration
string TableAlias1 { get; set; }
Property Value
Type Description
string

TableAlias2

The alias to give the second table.

Declaration
string TableAlias2 { get; set; }
Property Value
Type Description
string

UniqueID

A unique id for this operator.

Declaration
int UniqueID { get; }
Property Value
Type Description
int

WholeExpression

Any valid SQL comparison expression to use instead.

Declaration
string WholeExpression { get; set; }
Property Value
Type Description
string

Methods

GetJoiningSQLForItemsInGroup()

Declaration
string GetJoiningSQLForItemsInGroup()
Returns
Type Description
string

GetOpConditionSql()

Generates the operator condition SQL.

Declaration
string GetOpConditionSql()
Returns
Type Description
string

SQL

Extension Methods