Class SelectQuery

Namespace

LinqToDB.SqlQuery

Assembly

linq2db.dll

public class SelectQuery : ISqlTableSource, ISqlExpression, IQueryElement, IEquatable<ISqlExpression>, ISqlExpressionWalkable

Inheritance

object

SelectQuery

Implements

ISqlTableSource

ISqlExpression

IQueryElement

IEquatable<ISqlExpression>

ISqlExpressionWalkable

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>)

QueryHelper.GetExpressionType(ISqlExpression)

QueryHelper.IsComplexExpression(ISqlExpression)

QueryHelper.ShouldCheckForNull(ISqlExpression)

JoinExtensions.CrossApply(ISqlTableSource, params SqlFromClause.Join[])

JoinExtensions.CrossApply(ISqlTableSource, string, params SqlFromClause.Join[])

JoinExtensions.FullJoin(ISqlTableSource, params SqlFromClause.Join[])

JoinExtensions.FullJoin(ISqlTableSource, string, params SqlFromClause.Join[])

JoinExtensions.InnerJoin(ISqlTableSource, params SqlFromClause.Join[])

JoinExtensions.InnerJoin(ISqlTableSource, string, params SqlFromClause.Join[])

JoinExtensions.Join(ISqlTableSource, params SqlFromClause.Join[])

JoinExtensions.Join(ISqlTableSource, string, params SqlFromClause.Join[])

JoinExtensions.LeftJoin(ISqlTableSource, params SqlFromClause.Join[])

JoinExtensions.LeftJoin(ISqlTableSource, string, params SqlFromClause.Join[])

JoinExtensions.OuterApply(ISqlTableSource, params SqlFromClause.Join[])

JoinExtensions.OuterApply(ISqlTableSource, string, params SqlFromClause.Join[])

JoinExtensions.RightJoin(ISqlTableSource, params SqlFromClause.Join[])

JoinExtensions.RightJoin(ISqlTableSource, string, params SqlFromClause.Join[])

JoinExtensions.WeakInnerJoin(ISqlTableSource, params SqlFromClause.Join[])

JoinExtensions.WeakInnerJoin(ISqlTableSource, string, params SqlFromClause.Join[])

JoinExtensions.WeakJoin(ISqlTableSource, params SqlFromClause.Join[])

JoinExtensions.WeakJoin(ISqlTableSource, string, params SqlFromClause.Join[])

JoinExtensions.WeakLeftJoin(ISqlTableSource, params SqlFromClause.Join[])

JoinExtensions.WeakLeftJoin(ISqlTableSource, string, params SqlFromClause.Join[])

Sql.IsDistinctFrom<T>(T, T)

Sql.IsNotDistinctFrom<T>(T, T)

QueryHelper.FindJoin(SelectQuery, Func<SqlJoinedTable, bool>)

QueryHelper.RemoveNotUnusedColumns(SelectQuery)

QueryHelper.RootQuery(SelectQuery)

QueryHelper.TransformInnerJoinsToWhere(SelectQuery)

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>)

Constructors

SelectQuery()

public SelectQuery()

Fields

SourceIDCounter

public static int SourceIDCounter

Field Value

int

Properties

All

public SqlField All { get; }

Property Value

SqlField

CanBeNull

public bool CanBeNull { get; }

Property Value

bool

DebugSqlText

protected string DebugSqlText { get; }

Property Value

string

DoNotRemove

Gets or sets flag when sub-query can be removed during optimization.

public bool DoNotRemove { get; set; }

Property Value

bool

DoNotSetAliases

public bool DoNotSetAliases { get; set; }

Property Value

bool

ElementType

public QueryElementType ElementType { get; }

Property Value

QueryElementType

From

public SqlFromClause From { get; }

Property Value

SqlFromClause

GroupBy

public SqlGroupByClause GroupBy { get; }

Property Value

SqlGroupByClause

HasSetOperators

public bool HasSetOperators { get; }

Property Value

bool

HasUniqueKeys

public bool HasUniqueKeys { get; }

Property Value

bool

Having

public SqlWhereClause Having { get; }

Property Value

SqlWhereClause

IsParameterDependent

public bool IsParameterDependent { get; set; }

Property Value

bool

IsSimple

public bool IsSimple { get; }

Property Value

bool

IsSimpleOrSet

public bool IsSimpleOrSet { get; }

Property Value

bool

OrderBy

public SqlOrderByClause OrderBy { get; }

Property Value

SqlOrderByClause

ParentSelect

public SelectQuery? ParentSelect { get; set; }

Property Value

SelectQuery

Precedence

public int Precedence { get; }

Property Value

int

Properties

public List<object> Properties { get; }

Property Value

List<object>

QueryName

public string? QueryName { get; set; }

Property Value

string

Select

public SqlSelectClause Select { get; }

Property Value

SqlSelectClause

SetOperators

public List<SqlSetOperator> SetOperators { get; }

Property Value

List<SqlSetOperator>

SourceID

public int SourceID { get; }

Property Value

int

SqlQueryExtensions

public List<SqlQueryExtension>? SqlQueryExtensions { get; set; }

Property Value

List<SqlQueryExtension>

SqlTableType

public SqlTableType SqlTableType { get; }

Property Value

SqlTableType

SqlText

public string SqlText { get; }

Property Value

string

SystemType

public Type? SystemType { get; }

Property Value

Type

UniqueKeys

Contains list of columns that build unique key for this sub-query. Used in JoinOptimizer for safely removing sub-query from resulting SQL.

public List<ISqlExpression[]> UniqueKeys { get; }

Property Value

List<ISqlExpression[]>

Where

public SqlWhereClause Where { get; }

Property Value

SqlWhereClause

Methods

AddUnion(SelectQuery, bool)

public void AddUnion(SelectQuery union, bool isAll)

Parameters

union SelectQuery

isAll bool

Equals(ISqlExpression, Func<ISqlExpression, ISqlExpression, bool>)

public bool Equals(ISqlExpression other, Func<ISqlExpression, ISqlExpression, bool> comparer)

Parameters

other ISqlExpression

comparer Func<ISqlExpression, ISqlExpression, bool>

Returns

bool

ForEachTable<TContext>(TContext, Action<TContext, SqlTableSource>, HashSet<SelectQuery>)

public void ForEachTable<TContext>(TContext context, Action<TContext, SqlTableSource> action, HashSet<SelectQuery> visitedQueries)

Parameters

context TContext

action Action<TContext, SqlTableSource>

visitedQueries HashSet<SelectQuery>

Type Parameters

TContext

GetKeys(bool)

public IList<ISqlExpression> GetKeys(bool allIfEmpty)

Parameters

allIfEmpty bool

Returns

IList<ISqlExpression>

GetTableSource(ISqlTableSource)

public ISqlTableSource? GetTableSource(ISqlTableSource table)

Parameters

table ISqlTableSource

Returns

ISqlTableSource

ToString(StringBuilder, Dictionary<IQueryElement, IQueryElement>)

public StringBuilder ToString(StringBuilder sb, Dictionary<IQueryElement, IQueryElement> dic)

Parameters

sb StringBuilder

dic Dictionary<IQueryElement, IQueryElement>

Returns

StringBuilder

Walk<TContext>(WalkOptions, TContext, Func<TContext, ISqlExpression, ISqlExpression>)

public ISqlExpression Walk<TContext>(WalkOptions options, TContext context, Func<TContext, ISqlExpression, ISqlExpression> func)

Parameters

options WalkOptions

context TContext

func Func<TContext, ISqlExpression, ISqlExpression>

Returns

ISqlExpression

Type Parameters

TContext