Class SqlTable

Namespace

LinqToDB.SqlQuery

Assembly

linq2db.dll

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

Inheritance

object

SqlTable

Implements

ISqlTableSource

ISqlExpression

IQueryElement

IEquatable<ISqlExpression>

ISqlExpressionWalkable

Derived

SqlCteTable

SqlRawSqlTable

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

SqlTable(EntityDescriptor, string?)

public SqlTable(EntityDescriptor entityDescriptor, string? physicalName = null)

Parameters

entityDescriptor EntityDescriptor

physicalName string

SqlTable(SqlTable)

public SqlTable(SqlTable table)

Parameters

table SqlTable

SqlTable(SqlTable, IEnumerable<SqlField>, ISqlExpression[])

public SqlTable(SqlTable table, IEnumerable<SqlField> fields, ISqlExpression[] tableArguments)

Parameters

table SqlTable

fields IEnumerable<SqlField>

tableArguments ISqlExpression[]

SqlTable(Type, int?, SqlObjectName)

protected SqlTable(Type objectType, int? sourceId, SqlObjectName tableName)

Parameters

objectType Type

sourceId int?

tableName SqlObjectName

Properties

Alias

public string? Alias { get; set; }

Property Value

string

All

public SqlField All { get; }

Property Value

SqlField

CanBeNull

public bool CanBeNull { get; set; }

Property Value

bool

ElementType

public virtual QueryElementType ElementType { get; }

Property Value

QueryElementType

Expression

Custom SQL expression format string (used together with TableArguments) to transform SqlTable to custom table expression. Arguments:

• {0}: TableName
• {1}: Alias
• {2+}: arguments from TableArguments (with index adjusted by 2)

public string? Expression { get; set; }

Property Value

string

Fields

public IReadOnlyList<SqlField> Fields { get; }

Property Value

IReadOnlyList<SqlField>

ID

public virtual string? ID { get; set; }

Property Value

string

IdentityFields

public IReadOnlyList<SqlField> IdentityFields { get; }

Property Value

IReadOnlyList<SqlField>

ObjectType

public Type ObjectType { get; protected set; }

Property Value

Type

SequenceAttributes

public SequenceNameAttribute[]? SequenceAttributes { get; protected set; }

Property Value

SequenceNameAttribute[]

SourceID

public int SourceID { get; }

Property Value

int

SqlQueryExtensions

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

Property Value

List<SqlQueryExtension>

SqlTableType

public virtual SqlTableType SqlTableType { get; set; }

Property Value

SqlTableType

TableArguments

public ISqlExpression[]? TableArguments { get; set; }

Property Value

ISqlExpression[]

TableName

public virtual SqlObjectName TableName { get; set; }

Property Value

SqlObjectName

TableOptions

public TableOptions TableOptions { get; set; }

Property Value

TableOptions

Methods

Add(SqlField)

public void Add(SqlField field)

Parameters

field SqlField

AddRange(IEnumerable<SqlField>)

public void AddRange(IEnumerable<SqlField> collection)

Parameters

collection IEnumerable<SqlField>

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

FindFieldByMemberName(string)

Search for table field by mapping class member name.

public SqlField? FindFieldByMemberName(string memberName)

Parameters

memberName string

Mapping class member name.

Returns

SqlField

GetIdentityField()

public SqlField? GetIdentityField()

Returns

SqlField

GetKeys(bool)

public IList<ISqlExpression> GetKeys(bool allIfEmpty)

Parameters

allIfEmpty bool

Returns

IList<ISqlExpression>

ToString()

Returns a string that represents the current object.

public override string ToString()

Returns

string

A string that represents the current object.

ToString(StringBuilder, Dictionary<IQueryElement, IQueryElement>)

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