Class SqlTableSource

Namespace

LinqToDB.SqlQuery

Assembly

linq2db.dll

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

Inheritance

object

SqlTableSource

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)

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

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

CanBeNull

public bool CanBeNull { get; }

Property Value

bool

ElementType

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

Deconstruct(out ISqlTableSource)

public void Deconstruct(out ISqlTableSource source)

Parameters

source ISqlTableSource

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

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

GetJoinNumber()

public int GetJoinNumber()

Returns

int

GetTables()

public IEnumerable<ISqlTableSource> GetTables()

Returns

IEnumerable<ISqlTableSource>

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