Class SqlTable

Inheritance
System.Object
SqlTable
SqlCteTable
SqlRawSqlTable
SqlTable<T>
Implements
IEquatable<ISqlExpression>
Namespace: LinqToDB.SqlQuery
Assembly: linq2db.dll
Syntax
public class SqlTable : object, ISqlTableSource, ISqlExpression, IQueryElement, ISqlExpressionWalkable

Constructors

| Improve this Doc View Source

SqlTable(MappingSchema, Type, Nullable<String>)

Declaration
public SqlTable(MappingSchema mappingSchema, Type objectType, string? physicalName = null)
Parameters
Type Name Description
MappingSchema mappingSchema
Type objectType
System.Nullable<System.String> physicalName
| Improve this Doc View Source

SqlTable(SqlTable)

Declaration
public SqlTable(SqlTable table)
Parameters
Type Name Description
SqlTable table
| Improve this Doc View Source

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

Declaration
public SqlTable(SqlTable table, IEnumerable<SqlField> fields, ISqlExpression[] tableArguments)
Parameters
Type Name Description
SqlTable table
IEnumerable<SqlField> fields
ISqlExpression[] tableArguments
| Improve this Doc View Source

SqlTable(Type)

Declaration
public SqlTable(Type objectType)
Parameters
Type Name Description
Type objectType
| Improve this Doc View Source

SqlTable(Type, Nullable<Int32>, SqlObjectName)

Declaration
protected SqlTable(Type objectType, int? sourceId, SqlObjectName tableName)
Parameters
Type Name Description
Type objectType
System.Nullable<System.Int32> sourceId
LinqToDB.SqlQuery.SqlObjectName tableName

Properties

| Improve this Doc View Source

Alias

Declaration
public string? Alias { get; set; }
Property Value
Type Description
System.Nullable<System.String>
| Improve this Doc View Source

All

Declaration
public SqlField All { get; }
Property Value
Type Description
SqlField
| Improve this Doc View Source

CanBeNull

Declaration
public bool CanBeNull { get; set; }
Property Value
Type Description
System.Boolean
| Improve this Doc View Source

ElementType

Declaration
public virtual QueryElementType ElementType { get; }
Property Value
Type Description
QueryElementType
| Improve this Doc View Source

Expression

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

Declaration
public string? Expression { get; set; }
Property Value
Type Description
System.Nullable<System.String>
| Improve this Doc View Source

Fields

Declaration
public IReadOnlyList<SqlField> Fields { get; }
Property Value
Type Description
IReadOnlyList<SqlField>
| Improve this Doc View Source

ID

Declaration
public virtual string? ID { get; set; }
Property Value
Type Description
System.Nullable<System.String>
| Improve this Doc View Source

IdentityFields

Declaration
public IReadOnlyList<SqlField> IdentityFields { get; }
Property Value
Type Description
IReadOnlyList<SqlField>
| Improve this Doc View Source

ObjectType

Declaration
public Type ObjectType { get; protected set; }
Property Value
Type Description
Type
| Improve this Doc View Source

SequenceAttributes

Declaration
public SequenceNameAttribute[] SequenceAttributes { get; protected set; }
Property Value
Type Description
SequenceNameAttribute[]
| Improve this Doc View Source

SourceID

Declaration
public int SourceID { get; }
Property Value
Type Description
System.Int32
| Improve this Doc View Source

SqlQueryExtensions

Declaration
public List<SqlQueryExtension>? SqlQueryExtensions { get; set; }
Property Value
Type Description
System.Nullable<List<SqlQueryExtension>>
| Improve this Doc View Source

SqlTableType

Declaration
public virtual SqlTableType SqlTableType { get; set; }
Property Value
Type Description
SqlTableType
| Improve this Doc View Source

TableArguments

Declaration
public ISqlExpression[] TableArguments { get; set; }
Property Value
Type Description
ISqlExpression[]
| Improve this Doc View Source

TableName

Declaration
public virtual SqlObjectName TableName { get; set; }
Property Value
Type Description
LinqToDB.SqlQuery.SqlObjectName
| Improve this Doc View Source

TableOptions

Declaration
public TableOptions TableOptions { get; set; }
Property Value
Type Description
TableOptions

Methods

| Improve this Doc View Source

Add(SqlField)

Declaration
public void Add(SqlField field)
Parameters
Type Name Description
SqlField field
| Improve this Doc View Source

AddRange(IEnumerable<SqlField>)

Declaration
public void AddRange(IEnumerable<SqlField> collection)
Parameters
Type Name Description
IEnumerable<SqlField> collection
| Improve this Doc View Source

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

Declaration
public bool Equals(ISqlExpression other, Func<ISqlExpression, ISqlExpression, bool> comparer)
Parameters
Type Name Description
ISqlExpression other
Func<ISqlExpression, ISqlExpression, System.Boolean> comparer
Returns
Type Description
System.Boolean
| Improve this Doc View Source

FindFieldByMemberName(String)

Search for table field by mapping class member name.

Declaration
public SqlField FindFieldByMemberName(string memberName)
Parameters
Type Name Description
System.String memberName

Mapping class member name.
Returns
Type Description
SqlField
| Improve this Doc View Source

GetIdentityField()

Declaration
public SqlField GetIdentityField()
Returns
Type Description
SqlField
| Improve this Doc View Source

GetKeys(Boolean)

Declaration
public IList<ISqlExpression> GetKeys(bool allIfEmpty)
Parameters
Type Name Description
System.Boolean allIfEmpty
Returns
Type Description
IList<ISqlExpression>
| Improve this Doc View Source

ToString()

Declaration
public override string ToString()
Returns
Type Description
System.String
| Improve this Doc View Source

ToString(StringBuilder, Dictionary<IQueryElement, IQueryElement>)

Declaration
public virtual StringBuilder ToString(StringBuilder sb, Dictionary<IQueryElement, IQueryElement> dic)
Parameters
Type Name Description
StringBuilder sb
Dictionary<IQueryElement, IQueryElement> dic
Returns
Type Description
StringBuilder
| Improve this Doc View Source

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

Declaration
public virtual ISqlExpression Walk<TContext>(WalkOptions options, TContext context, Func<TContext, ISqlExpression, ISqlExpression> func)
Parameters
Type Name Description
WalkOptions options
TContext context
Func<TContext, ISqlExpression, ISqlExpression> func
Returns
Type Description
ISqlExpression
Type Parameters
Name Description
TContext

Explicit Interface Implementations

| Improve this Doc View Source

ISqlExpression.Precedence

Declaration
int ISqlExpression.Precedence { get; }
Returns
Type Description
System.Int32

Implements

IEquatable<>

Extension Methods