Class SqlSelectClause

Namespace

LinqToDB.Internal.SqlQuery

Assembly

linq2db.dll

public sealed class SqlSelectClause : ClauseBase, IQueryElement

Inheritance

object

QueryElement

ClauseBase

SqlSelectClause

Implements

IQueryElement

Inherited Members

ClauseBase.Select

ClauseBase.From

ClauseBase.Where

ClauseBase.GroupBy

ClauseBase.Having

ClauseBase.OrderBy

QueryElement.ReferenceComparer

object.GetType()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Extension Methods

QueryHelper.CanBeEvaluated(IQueryElement, EvaluationContext)

QueryHelper.CanBeEvaluated(IQueryElement, bool)

QueryHelper.EvaluateBoolExpression(IQueryElement, EvaluationContext, bool?)

QueryHelper.EvaluateExpression(IQueryElement, EvaluationContext)

QueryHelper.HasElement(IQueryElement, IQueryElement)

QueryHelper.HasParameter(IQueryElement)

QueryHelper.HasQueryParameter(IQueryElement)

QueryHelper.IsMutable(IQueryElement)

QueryHelper.TryEvaluateExpression(IQueryElement, EvaluationContext, out object?)

QueryHelper.TryEvaluateExpressionForServer(IQueryElement, EvaluationContext, out object?)

QueryVisitorExtensions.Find(IQueryElement?, QueryElementType)

QueryVisitorExtensions.Find(IQueryElement?, Func<IQueryElement, bool>)

QueryVisitorExtensions.FindExcept<TContext>(IQueryElement?, TContext, IQueryElement, Func<TContext, IQueryElement, bool>)

QueryVisitorExtensions.Find<TContext>(IQueryElement?, TContext, Func<TContext, IQueryElement, bool>)

QueryVisitorExtensions.Visit(IQueryElement, Action<IQueryElement>)

QueryVisitorExtensions.VisitAll(IQueryElement, Action<IQueryElement>)

QueryVisitorExtensions.VisitAll<TContext>(IQueryElement, TContext, Action<TContext, IQueryElement>)

QueryVisitorExtensions.VisitParentFirst(IQueryElement, Func<IQueryElement, bool>)

QueryVisitorExtensions.VisitParentFirstAll(IQueryElement, Func<IQueryElement, bool>)

QueryVisitorExtensions.VisitParentFirstAll<TContext>(IQueryElement, TContext, Func<TContext, IQueryElement, bool>)

QueryVisitorExtensions.VisitParentFirst<TContext>(IQueryElement, TContext, Func<TContext, IQueryElement, bool>)

QueryVisitorExtensions.Visit<TContext>(IQueryElement, TContext, Action<TContext, IQueryElement>)

QueryVisitorExtensions.Clone<T>(T?)

QueryVisitorExtensions.Clone<T>(T?, Dictionary<IQueryElement, IQueryElement>)

QueryVisitorExtensions.Clone<T>(T?, Func<IQueryElement, bool>)

QueryVisitorExtensions.Clone<T, TContext>(T?, TContext, Dictionary<IQueryElement, IQueryElement>, Func<TContext, IQueryElement, bool>)

QueryVisitorExtensions.Clone<T, TContext>(T?, TContext, Func<TContext, IQueryElement, bool>)

QueryVisitorExtensions.ConvertAll<T>(T, bool, Func<SqlQueryConvertVisitor<object?>, IQueryElement, IQueryElement>)

QueryVisitorExtensions.ConvertAll<TContext, T>(T, TContext, bool, Func<SqlQueryConvertVisitor<TContext>, IQueryElement, IQueryElement>)

QueryVisitorExtensions.ConvertAll<TContext, T>(T, TContext, Func<SqlQueryConvertVisitor<TContext>, IQueryElement, IQueryElement>)

QueryVisitorExtensions.Convert<T>(T, Func<SqlQueryConvertVisitor<object?>, IQueryElement, IQueryElement>)

QueryVisitorExtensions.Convert<T>(T, Func<SqlQueryConvertVisitor<object?>, IQueryElement, IQueryElement>, bool)

QueryVisitorExtensions.Convert<TContext, T>(T, TContext, bool, Func<SqlQueryConvertVisitor<TContext>, IQueryElement, IQueryElement>)

QueryVisitorExtensions.Convert<TContext, T>(T, TContext, bool, Func<SqlQueryConvertVisitor<TContext>, IQueryElement, IQueryElement>, bool)

QueryVisitorExtensions.Convert<TContext, T>(T, TContext, Func<SqlQueryConvertVisitor<TContext>, IQueryElement, IQueryElement>)

QueryVisitorExtensions.Convert<TContext, T>(T, TContext, Func<SqlQueryConvertVisitor<TContext>, IQueryElement, IQueryElement>, bool)

QueryVisitorExtensions.Replace<T>(T, IDictionary<IQueryElement, IQueryElement>, params IQueryElement[])

SqlExtensions.HasSomeModifiers(SqlSelectClause, bool, bool)

Sql.IsDistinctFrom<T>(T, T)

Sql.IsDistinctFrom<T>(T, T)

Sql.IsDistinctFrom<T>(T, T)

Sql.IsDistinctFrom<T>(T, T)

Sql.IsDistinctFrom<T>(T, T)

Sql.IsNotDistinctFrom<T>(T, T)

Sql.IsNotDistinctFrom<T>(T, T)

Sql.IsNotDistinctFrom<T>(T, T)

Sql.IsNotDistinctFrom<T>(T, T)

Sql.IsNotDistinctFrom<T>(T, T)

SqlExtensions.In<T>(T, T, T)

SqlExtensions.In<T>(T, T, T)

SqlExtensions.In<T>(T, T, T)

SqlExtensions.In<T>(T, T, T)

SqlExtensions.In<T>(T, T, T)

SqlExtensions.In<T>(T, T, T, T)

SqlExtensions.In<T>(T, T, T, T)

SqlExtensions.In<T>(T, T, T, T)

SqlExtensions.In<T>(T, T, T, T)

SqlExtensions.In<T>(T, T, T, T)

SqlExtensions.In<T>(T, params T[])

SqlExtensions.In<T>(T, params T[])

SqlExtensions.In<T>(T, params T[])

SqlExtensions.In<T>(T, params T[])

SqlExtensions.In<T>(T, params T[])

SqlExtensions.In<T>(T, IEnumerable<T>)

SqlExtensions.In<T>(T, IEnumerable<T>)

SqlExtensions.In<T>(T, IEnumerable<T>)

SqlExtensions.In<T>(T, IEnumerable<T>)

SqlExtensions.In<T>(T, IEnumerable<T>)

SqlExtensions.In<T>(T, IQueryable<T>)

SqlExtensions.In<T>(T, IQueryable<T>)

SqlExtensions.In<T>(T, IQueryable<T>)

SqlExtensions.In<T>(T, IQueryable<T>)

SqlExtensions.In<T>(T, IQueryable<T>)

SqlExtensions.NotIn<T>(T, T, T)

SqlExtensions.NotIn<T>(T, T, T)

SqlExtensions.NotIn<T>(T, T, T)

SqlExtensions.NotIn<T>(T, T, T)

SqlExtensions.NotIn<T>(T, T, T)

SqlExtensions.NotIn<T>(T, T, T, T)

SqlExtensions.NotIn<T>(T, T, T, T)

SqlExtensions.NotIn<T>(T, T, T, T)

SqlExtensions.NotIn<T>(T, T, T, T)

SqlExtensions.NotIn<T>(T, T, T, T)

SqlExtensions.NotIn<T>(T, params T[])

SqlExtensions.NotIn<T>(T, params T[])

SqlExtensions.NotIn<T>(T, params T[])

SqlExtensions.NotIn<T>(T, params T[])

SqlExtensions.NotIn<T>(T, params T[])

SqlExtensions.NotIn<T>(T, IEnumerable<T>)

SqlExtensions.NotIn<T>(T, IEnumerable<T>)

SqlExtensions.NotIn<T>(T, IEnumerable<T>)

SqlExtensions.NotIn<T>(T, IEnumerable<T>)

SqlExtensions.NotIn<T>(T, IEnumerable<T>)

SqlExtensions.NotIn<T>(T, IQueryable<T>)

SqlExtensions.NotIn<T>(T, IQueryable<T>)

SqlExtensions.NotIn<T>(T, IQueryable<T>)

SqlExtensions.NotIn<T>(T, IQueryable<T>)

SqlExtensions.NotIn<T>(T, IQueryable<T>)

Utils.IsNullValue(object?)

Utils.IsNullValue(object?)

Utils.IsNullValue(object?)

Utils.IsNullValue(object?)

Utils.IsNullValue(object?)

Properties

Columns

public List<SqlColumn> Columns { get; }

Property Value

List<SqlColumn>

ElementType

AST node type.

public override QueryElementType ElementType { get; }

Property Value

QueryElementType

HasModifier

public bool HasModifier { get; }

Property Value

bool

IsDistinct

public bool IsDistinct { get; set; }

Property Value

bool

OptimizeDistinct

public bool OptimizeDistinct { get; set; }

Property Value

bool

SkipValue

public ISqlExpression? SkipValue { get; set; }

Property Value

ISqlExpression

TakeHints

public TakeHints? TakeHints { get; }

Property Value

TakeHints?

TakeValue

public ISqlExpression? TakeValue { get; }

Property Value

ISqlExpression

Methods

Add(ISqlExpression)

public int Add(ISqlExpression expr)

Parameters

expr ISqlExpression

Returns

int

Add(ISqlExpression, string?)

public int Add(ISqlExpression expr, string? alias)

Parameters

expr ISqlExpression

alias string

Returns

int

AddColumn(ISqlExpression)

public SqlColumn AddColumn(ISqlExpression expr)

Parameters

expr ISqlExpression

Returns

SqlColumn

AddNew(ISqlExpression, string?)

public int AddNew(ISqlExpression expr, string? alias = null)

Parameters

expr ISqlExpression

alias string

Returns

int

AddNewColumn(ISqlExpression)

public SqlColumn AddNewColumn(ISqlExpression expr)

Parameters

expr ISqlExpression

Returns

SqlColumn

Cleanup()

public void Cleanup()

Expr(DbDataType, string, params ISqlExpression[])

public SqlSelectClause Expr(DbDataType type, string expr, params ISqlExpression[] values)

Parameters

type DbDataType

expr string

values ISqlExpression[]

Returns

SqlSelectClause

Expr(DbDataType, string, int, params ISqlExpression[])

public SqlSelectClause Expr(DbDataType type, string expr, int priority, params ISqlExpression[] values)

Parameters

type DbDataType

expr string

priority int

values ISqlExpression[]

Returns

SqlSelectClause

Expr(DbDataType, string, string, int, params ISqlExpression[])

public SqlSelectClause Expr(DbDataType type, string alias, string expr, int priority, params ISqlExpression[] values)

Parameters

type DbDataType

alias string

expr string

priority int

values ISqlExpression[]

Returns

SqlSelectClause

Expr(ISqlExpression)

public SqlSelectClause Expr(ISqlExpression expr)

Parameters

expr ISqlExpression

Returns

SqlSelectClause

Expr(ISqlExpression, string)

public SqlSelectClause Expr(ISqlExpression expr, string alias)

Parameters

expr ISqlExpression

alias string

Returns

SqlSelectClause

ExprNew(ISqlExpression)

public SqlSelectClause ExprNew(ISqlExpression expr)

Parameters

expr ISqlExpression

Returns

SqlSelectClause

Expr<T>(ISqlExpression, string, ISqlExpression)

public SqlSelectClause Expr<T>(ISqlExpression expr1, string operation, ISqlExpression expr2)

Parameters

expr1 ISqlExpression

operation string

expr2 ISqlExpression

Returns

SqlSelectClause

Type Parameters

T

Expr<T>(ISqlExpression, string, ISqlExpression, int)

public SqlSelectClause Expr<T>(ISqlExpression expr1, string operation, ISqlExpression expr2, int priority)

Parameters

expr1 ISqlExpression

operation string

expr2 ISqlExpression

priority int

Returns

SqlSelectClause

Type Parameters

T

Expr<T>(string, ISqlExpression, string, ISqlExpression, int)

public SqlSelectClause Expr<T>(string alias, ISqlExpression expr1, string operation, ISqlExpression expr2, int priority)

Parameters

alias string

expr1 ISqlExpression

operation string

expr2 ISqlExpression

priority int

Returns

SqlSelectClause

Type Parameters

T

Field(SqlField)

public SqlSelectClause Field(SqlField field)

Parameters

field SqlField

Returns

SqlSelectClause

Field(SqlField, string)

public SqlSelectClause Field(SqlField field, string alias)

Parameters

field SqlField

alias string

Returns

SqlSelectClause

GetElementHashCode()

public override int GetElementHashCode()

Returns

int

Skip(ISqlExpression)

public SqlSelectClause Skip(ISqlExpression value)

Parameters

value ISqlExpression

Returns

SqlSelectClause

Skip(int)

public SqlSelectClause Skip(int value)

Parameters

value int

Returns

SqlSelectClause

SubQuery(SelectQuery)

public SqlSelectClause SubQuery(SelectQuery subQuery)

Parameters

subQuery SelectQuery

Returns

SqlSelectClause

SubQuery(SelectQuery, string)

public SqlSelectClause SubQuery(SelectQuery selectQuery, string alias)

Parameters

selectQuery SelectQuery

alias string

Returns

SqlSelectClause

Take(ISqlExpression?, TakeHints?)

public SqlSelectClause Take(ISqlExpression? value, TakeHints? hints)

Parameters

value ISqlExpression

hints TakeHints?

Returns

SqlSelectClause

Take(int, TakeHints?)

public SqlSelectClause Take(int value, TakeHints? hints)

Parameters

value int

hints TakeHints?

Returns

SqlSelectClause

ToString(QueryElementTextWriter)

Generates debug text representation of AST node.

public override QueryElementTextWriter ToString(QueryElementTextWriter writer)

Parameters

writer QueryElementTextWriter

Returns

QueryElementTextWriter