WhereCondition

Classes > Nimblesite.Sql.Model > WhereCondition

Represents a WHERE condition - a closed type hierarchy for different condition types

public abstract record WhereCondition : IEquatable<WhereCondition>

Methods

Comparison(ColumnInfo, ComparisonOperator, string)

public static WhereCondition Comparison(ColumnInfo left, ComparisonOperator @operator, string right)

Creates a comparison condition (e.g., column = value)

Parameters:

Name Type Description
left ColumnInfo
operator ComparisonOperator
right String

Returns: WhereCondition

And()

public static WhereCondition And()

Creates a logical operator (AND, OR)

Returns: WhereCondition

Or()

public static WhereCondition Or()

Creates a logical operator (AND, OR)

Returns: WhereCondition

OpenParen()

public static WhereCondition OpenParen()

Creates an opening parenthesis

Returns: WhereCondition

CloseParen()

public static WhereCondition CloseParen()

Creates a closing parenthesis

Returns: WhereCondition

FromExpression(string)

public static WhereCondition FromExpression(string expression)

Creates a raw expression condition

Parameters:

Name Type Description
expression String

Returns: WhereCondition