Class WhereBuilder

Namespace

FluentCommand.Query

Assembly

FluentCommand.dll

Provides a builder for constructing SQL WHERE clauses with fluent, chainable methods.

public class WhereBuilder : WhereBuilder<WhereBuilder>, IStatementBuilder, IQueryBuilder

Inheritance

object

StatementBuilder<WhereBuilder>

WhereBuilder<WhereBuilder>

WhereBuilder

Implements

IStatementBuilder

IQueryBuilder

Inherited Members

WhereBuilder<WhereBuilder>.Where<TValue>(string, TValue, FilterOperators)

WhereBuilder<WhereBuilder>.Where<TValue>(string, TValue, string, FilterOperators)

WhereBuilder<WhereBuilder>.WhereIn<TValue>(string, IEnumerable<TValue>, string)

WhereBuilder<WhereBuilder>.WhereInIf<TValue>(string, IEnumerable<TValue>, Func<string, IEnumerable<TValue>, bool>)

WhereBuilder<WhereBuilder>.WhereInIf<TValue>(string, IEnumerable<TValue>, string, Func<string, IEnumerable<TValue>, bool>)

WhereBuilder<WhereBuilder>.WhereIf<TValue>(string, TValue, FilterOperators, Func<string, TValue, bool>)

WhereBuilder<WhereBuilder>.WhereIf<TValue>(string, TValue, string, FilterOperators, Func<string, TValue, bool>)

WhereBuilder<WhereBuilder>.WhereRaw(string, IEnumerable<QueryParameter>)

WhereBuilder<WhereBuilder>.WhereRawIf(string, IEnumerable<QueryParameter>, Func<string, IEnumerable<QueryParameter>, bool>)

WhereBuilder<WhereBuilder>.WhereOr(Action<LogicalBuilder>)

WhereBuilder<WhereBuilder>.WhereAnd(Action<LogicalBuilder>)

WhereBuilder<WhereBuilder>.WhereExpressions

WhereBuilder<WhereBuilder>.LogicalOperator

StatementBuilder<WhereBuilder>.Tag(string, string, string, int)

StatementBuilder<WhereBuilder>.Comment(string)

StatementBuilder<WhereBuilder>.NextParameter()

StatementBuilder<WhereBuilder>.QueryGenerator

StatementBuilder<WhereBuilder>.Parameters

StatementBuilder<WhereBuilder>.CommentExpressions

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Constructors

WhereBuilder(IQueryGenerator, List<QueryParameter>, LogicalOperators)

Initializes a new instance of the WhereBuilder class.

public WhereBuilder(IQueryGenerator queryGenerator, List<QueryParameter> parameters, LogicalOperators logicalOperator = LogicalOperators.And)

Parameters

queryGenerator IQueryGenerator

The IQueryGenerator used to generate SQL expressions.

parameters List<QueryParameter>

The list of QueryParameter objects for the query.

logicalOperator LogicalOperators

The logical operator (LogicalOperators) to combine WHERE expressions. Defaults to And.

Methods

BuildStatement()

Builds and returns a QueryStatement representing the SQL query and its parameters.

public override QueryStatement BuildStatement()

Returns

QueryStatement

A QueryStatement containing the SQL statement and associated QueryParameter values.