Class SqlSelectClause

Namespace

LinqToDB.SqlQuery

Assembly

linq2db.dll

public class SqlSelectClause : ClauseBase, IQueryElement, ISqlExpressionWalkable

Inheritance

object

ClauseBase

SqlSelectClause

Implements

IQueryElement

ISqlExpressionWalkable

Inherited Members

ClauseBase.Select

ClauseBase.From

ClauseBase.Where

ClauseBase.GroupBy

ClauseBase.Having

ClauseBase.OrderBy

ClauseBase.End()

ClauseBase.SelectQuery

Extension Methods

QueryHelper.CanBeEvaluated(IQueryElement, EvaluationContext)

QueryHelper.CanBeEvaluated(IQueryElement, bool)

QueryHelper.EvaluateBoolExpression(IQueryElement, EvaluationContext, bool?)

QueryHelper.EvaluateExpression(IQueryElement, EvaluationContext)

QueryHelper.IsMutable(IQueryElement)

QueryHelper.ToDebugString(IQueryElement)

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

QueryVisitorExtensions.Find(IQueryElement?, QueryElementType)

QueryVisitorExtensions.Find(IQueryElement?, Func<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>)

Sql.IsDistinctFrom<T>(T, T)

Sql.IsNotDistinctFrom<T>(T, T)

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<ConvertVisitor<object?>, IQueryElement, IQueryElement>)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Properties

Columns

public List<SqlColumn> Columns { get; }

Property Value

List<SqlColumn>

ElementType

public 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

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

Expr(string, params ISqlExpression[])

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

Parameters

expr string

values ISqlExpression[]

Returns

SqlSelectClause

Expr(string, int, params ISqlExpression[])

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

Parameters

expr string

priority int

values ISqlExpression[]

Returns

SqlSelectClause

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

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

Parameters

alias string

expr string

priority int

values ISqlExpression[]

Returns

SqlSelectClause

Expr(Type, string, params ISqlExpression[])

public SqlSelectClause Expr(Type systemType, string expr, params ISqlExpression[] values)

Parameters

systemType Type

expr string

values ISqlExpression[]

Returns

SqlSelectClause

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

public SqlSelectClause Expr(Type systemType, string expr, int priority, params ISqlExpression[] values)

Parameters

systemType Type

expr string

priority int

values ISqlExpression[]

Returns

SqlSelectClause

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

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

Parameters

systemType Type

alias string

expr string

priority int

values ISqlExpression[]

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

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