Class SqlTableSource

Namespace

LinqToDB.Internal.SqlQuery

Assembly

linq2db.dll

public sealed class SqlTableSource : SqlExpressionBase, ISqlTableSource, ISqlExpression, IQueryElement, IEquatable<ISqlExpression>

Inheritance

object

QueryElement

SqlExpressionBase

SqlTableSource

Implements

ISqlTableSource

ISqlExpression

IQueryElement

IEquatable<ISqlExpression>

Inherited Members

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

QueryHelper.CanBeNullableOrUnknown(ISqlExpression, NullabilityContext, bool)

QueryHelper.IsNullValue(ISqlExpression)

QueryHelper.IsPredicate(ISqlExpression)

QueryHelper.ShouldCheckForNull(ISqlExpression, NullabilityContext)

ISqlExpressionExtensions.AreEqual(ISqlExpression?, ISqlExpression?, Func<ISqlExpression, ISqlExpression, bool>)

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.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.WeakLeftJoin(ISqlTableSource, params SqlFromClause.Join[])

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

SqlExtensions.CreateCount(ISqlTableSource, MappingSchema)

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

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

Constructors

SqlTableSource(ISqlTableSource, string?)

public SqlTableSource(ISqlTableSource source, string? alias)

Parameters

source ISqlTableSource

alias string

SqlTableSource(ISqlTableSource, string?, params SqlJoinedTable[]?)

public SqlTableSource(ISqlTableSource source, string? alias, params SqlJoinedTable[]? joins)

Parameters

source ISqlTableSource

alias string

joins SqlJoinedTable[]

SqlTableSource(ISqlTableSource, string?, IEnumerable<SqlJoinedTable>, IEnumerable<ISqlExpression[]>?)

public SqlTableSource(ISqlTableSource source, string? alias, IEnumerable<SqlJoinedTable> joins, IEnumerable<ISqlExpression[]>? uniqueKeys)

Parameters

source ISqlTableSource

alias string

joins IEnumerable<SqlJoinedTable>

uniqueKeys IEnumerable<ISqlExpression[]>

Properties

Alias

public string? Alias { get; set; }

Property Value

string

All

public SqlField All { get; }

Property Value

SqlField

ElementType

AST node type.

public override QueryElementType ElementType { get; }

Property Value

QueryElementType

HasUniqueKeys

public bool HasUniqueKeys { get; }

Property Value

bool

this[ISqlTableSource]

public SqlTableSource? this[ISqlTableSource table] { get; }

Parameters

table ISqlTableSource

Property Value

SqlTableSource

this[ISqlTableSource, string?]

public SqlTableSource? this[ISqlTableSource table, string? alias] { get; }

Parameters

table ISqlTableSource

alias string

Property Value

SqlTableSource

Joins

public List<SqlJoinedTable> Joins { get; }

Property Value

List<SqlJoinedTable>

Precedence

public override int Precedence { get; }

Property Value

int

Source

public ISqlTableSource Source { get; set; }

Property Value

ISqlTableSource

SourceID

public int SourceID { get; }

Property Value

int

SqlTableType

public SqlTableType SqlTableType { get; }

Property Value

SqlTableType

SystemType

public override Type? SystemType { get; }

Property Value

Type

UniqueKeys

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

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

Property Value

List<ISqlExpression[]>

Methods

CanBeNullable(NullabilityContext)

public override bool CanBeNullable(NullabilityContext nullability)

Parameters

nullability NullabilityContext

Returns

bool

Deconstruct(out ISqlTableSource)

public void Deconstruct(out ISqlTableSource source)

Parameters

source ISqlTableSource

Equals(ISqlExpression?)

public override bool Equals(ISqlExpression? other)

Parameters

other ISqlExpression

Returns

bool

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

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

Parameters

other ISqlExpression

comparer Func<ISqlExpression, ISqlExpression, bool>

Returns

bool

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

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

Parameters

context TContext

action Action<TContext, SqlTableSource>

visitedQueries HashSet<SelectQuery>

Type Parameters

TContext

GetElementHashCode()

public override int GetElementHashCode()

Returns

int

GetJoinNumber()

public int GetJoinNumber()

Returns

int

GetTables()

public IEnumerable<ISqlTableSource> GetTables()

Returns

IEnumerable<ISqlTableSource>

Modify(ISqlTableSource)

public void Modify(ISqlTableSource source)

Parameters

source ISqlTableSource

ToString(QueryElementTextWriter)

Generates debug text representation of AST node.

public override QueryElementTextWriter ToString(QueryElementTextWriter writer)

Parameters

writer QueryElementTextWriter

Returns

QueryElementTextWriter