Class SelectBuilder

Namespace

FluentCommand.Query

Assembly

FluentCommand.dll

Provides a builder for constructing SQL SELECT statements with fluent, chainable methods.

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

Inheritance

object

StatementBuilder<SelectBuilder>

WhereBuilder<SelectBuilder>

SelectBuilder<SelectBuilder>

SelectBuilder

Implements

IStatementBuilder

IQueryBuilder

Inherited Members

SelectBuilder<SelectBuilder>.Column(string, string, string)

SelectBuilder<SelectBuilder>.ColumnIf(string, string, string, Func<string, bool>)

SelectBuilder<SelectBuilder>.Columns(IEnumerable<string>, string)

SelectBuilder<SelectBuilder>.Count(string, string, string)

SelectBuilder<SelectBuilder>.Aggregate(AggregateFunctions, string, string, string)

SelectBuilder<SelectBuilder>.From(string, string, string)

SelectBuilder<SelectBuilder>.From<TEntity>(string)

SelectBuilder<SelectBuilder>.FromRaw(string)

SelectBuilder<SelectBuilder>.Join(Action<JoinBuilder>)

SelectBuilder<SelectBuilder>.OrderBy(string, SortDirections)

SelectBuilder<SelectBuilder>.OrderBy(string, string, SortDirections)

SelectBuilder<SelectBuilder>.OrderByIf(string, SortDirections, Func<string, bool>)

SelectBuilder<SelectBuilder>.OrderByIf(string, string, SortDirections, Func<string, bool>)

SelectBuilder<SelectBuilder>.OrderByRaw(string)

SelectBuilder<SelectBuilder>.OrderByRawIf(string, Func<string, bool>)

SelectBuilder<SelectBuilder>.OrderByRaw(IEnumerable<string>)

SelectBuilder<SelectBuilder>.GroupBy(string, string)

SelectBuilder<SelectBuilder>.Limit(int, int)

SelectBuilder<SelectBuilder>.Page(int, int)

SelectBuilder<SelectBuilder>.BuildStatement()

SelectBuilder<SelectBuilder>.SelectExpressions

SelectBuilder<SelectBuilder>.FromExpressions

SelectBuilder<SelectBuilder>.SortExpressions

SelectBuilder<SelectBuilder>.GroupExpressions

SelectBuilder<SelectBuilder>.JoinExpressions

SelectBuilder<SelectBuilder>.LimitExpressions

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

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

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

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

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

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

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

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

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

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

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

WhereBuilder<SelectBuilder>.WhereExpressions

WhereBuilder<SelectBuilder>.LogicalOperator

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

StatementBuilder<SelectBuilder>.Comment(string)

StatementBuilder<SelectBuilder>.NextParameter()

StatementBuilder<SelectBuilder>.QueryGenerator

StatementBuilder<SelectBuilder>.Parameters

StatementBuilder<SelectBuilder>.CommentExpressions

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Constructors

SelectBuilder(IQueryGenerator, List<QueryParameter>, LogicalOperators)

Initializes a new instance of the SelectBuilder class.

public SelectBuilder(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.