Interface ITable<T>

Table-like queryable source, e.g. table, view or table-valued function.

Inherited Members

IExpressionQuery<T>.Expression

IQueryProviderAsync.ExecuteAsyncEnumerable<TResult>(Expression, CancellationToken)

IQueryProviderAsync.ExecuteAsync<TResult>(Expression, CancellationToken)

IExpressionQuery.SqlText

IExpressionQuery.DataContext

Namespace: LinqToDB

Assembly: linq2db.dll

Syntax

public interface ITable<out T> : IExpressionQuery<T>, IQueryProviderAsync, IExpressionQuery

Type Parameters

Name	Description
T	Record mapping type.

Properties

DatabaseName

Declaration

string? DatabaseName { get; }

Property Value

Type	Description
System.Nullable<System.String>

SchemaName

Declaration

string? SchemaName { get; }

Property Value

Type	Description
System.Nullable<System.String>

ServerName

Declaration

string? ServerName { get; }

Property Value

Type	Description
System.Nullable<System.String>

TableID

Declaration

string? TableID { get; }

Property Value

Type	Description
System.Nullable<System.String>

TableName

Declaration

string TableName { get; }

Property Value

Type	Description
System.String

TableOptions

Declaration

TableOptions TableOptions { get; }

Property Value

Type	Description
TableOptions

Extension Methods

MappingSchemaExtensions.GetEqualityComparer<T>(ITable<T>, Func<ColumnDescriptor, Boolean>)

MappingSchemaExtensions.GetEntityEqualityComparer<T>(ITable<T>)

MappingSchemaExtensions.GetKeyEqualityComparer<T>(ITable<T>)

Map.DeepCopy<T>(T)

DataExtensions.DropTable<T>(ITable<T>, Nullable<String>, Nullable<String>, Nullable<String>, Nullable<Boolean>, Nullable<String>, TableOptions)

DataExtensions.DropTableAsync<T>(ITable<T>, Nullable<String>, Nullable<String>, Nullable<String>, Nullable<Boolean>, Nullable<String>, TableOptions, CancellationToken)

LinqExtensions.TableID<T>(ITable<T>, Nullable<String>)

LinqExtensions.TableName<T>(ITable<T>, String)

LinqExtensions.DatabaseName<T>(ITable<T>, Nullable<String>)

LinqExtensions.ServerName<T>(ITable<T>, Nullable<String>)

LinqExtensions.SchemaName<T>(ITable<T>, Nullable<String>)

LinqExtensions.WithTableExpression<T>(ITable<T>, String)

LinqExtensions.With<TSource>(ITable<TSource>, String)

LinqExtensions.TableHint<TSource>(ITable<TSource>, String)

LinqExtensions.TableHint<TSource, TParam>(ITable<TSource>, String, TParam)

LinqExtensions.TableHint<TSource, TParam>(ITable<TSource>, String, TParam[])

LinqExtensions.IndexHint<TSource>(ITable<TSource>, String)

LinqExtensions.IndexHint<TSource, TParam>(ITable<TSource>, String, TParam)

LinqExtensions.IndexHint<TSource, TParam>(ITable<TSource>, String, TParam[])

LinqExtensions.Insert<T>(ITable<T>, Expression<Func<T>>)

LinqExtensions.InsertAsync<T>(ITable<T>, Expression<Func<T>>, CancellationToken)

LinqExtensions.InsertWithIdentity<T>(ITable<T>, Expression<Func<T>>)

LinqExtensions.InsertWithInt32Identity<T>(ITable<T>, Expression<Func<T>>)

LinqExtensions.InsertWithInt64Identity<T>(ITable<T>, Expression<Func<T>>)

LinqExtensions.InsertWithDecimalIdentity<T>(ITable<T>, Expression<Func<T>>)

LinqExtensions.InsertWithIdentityAsync<T>(ITable<T>, Expression<Func<T>>, CancellationToken)

LinqExtensions.InsertWithInt32IdentityAsync<T>(ITable<T>, Expression<Func<T>>, CancellationToken)

LinqExtensions.InsertWithInt64IdentityAsync<T>(ITable<T>, Expression<Func<T>>, CancellationToken)

LinqExtensions.InsertWithDecimalIdentityAsync<T>(ITable<T>, Expression<Func<T>>, CancellationToken)

LinqExtensions.AsValueInsertable<T>(ITable<T>)

LinqExtensions.Value<T, TV>(ITable<T>, Expression<Func<T, TV>>, Expression<Func<TV>>)

LinqExtensions.Value<T, TV>(ITable<T>, Expression<Func<T, TV>>, TV)

LinqExtensions.InsertOrUpdate<T>(ITable<T>, Expression<Func<T>>, Nullable<Expression<Func<T, T>>>)

LinqExtensions.InsertOrUpdateAsync<T>(ITable<T>, Expression<Func<T>>, Nullable<Expression<Func<T, T>>>, CancellationToken)

LinqExtensions.InsertOrUpdate<T>(ITable<T>, Expression<Func<T>>, Nullable<Expression<Func<T, T>>>, Expression<Func<T>>)

LinqExtensions.InsertOrUpdateAsync<T>(ITable<T>, Expression<Func<T>>, Nullable<Expression<Func<T, T>>>, Expression<Func<T>>, CancellationToken)

LinqExtensions.Drop<T>(ITable<T>, Boolean)

LinqExtensions.DropAsync<T>(ITable<T>, Boolean, CancellationToken)

LinqExtensions.Truncate<T>(ITable<T>, Boolean)

LinqExtensions.TruncateAsync<T>(ITable<T>, Boolean, CancellationToken)

LinqExtensions.TagQuery<T>(ITable<T>, String)

LinqExtensions.InsertWithOutput<TTarget>(ITable<TTarget>, Expression<Func<TTarget>>)

LinqExtensions.InsertWithOutputAsync<TTarget>(ITable<TTarget>, Expression<Func<TTarget>>, CancellationToken)

LinqExtensions.InsertWithOutput<TTarget>(ITable<TTarget>, TTarget)

LinqExtensions.InsertWithOutputAsync<TTarget>(ITable<TTarget>, TTarget, CancellationToken)

LinqExtensions.InsertWithOutput<TTarget, TOutput>(ITable<TTarget>, Expression<Func<TTarget>>, Expression<Func<TTarget, TOutput>>)

LinqExtensions.InsertWithOutputAsync<TTarget, TOutput>(ITable<TTarget>, Expression<Func<TTarget>>, Expression<Func<TTarget, TOutput>>, CancellationToken)

LinqExtensions.InsertWithOutputInto<TTarget>(ITable<TTarget>, Expression<Func<TTarget>>, ITable<TTarget>)

LinqExtensions.InsertWithOutputIntoAsync<TTarget>(ITable<TTarget>, Expression<Func<TTarget>>, ITable<TTarget>, CancellationToken)

LinqExtensions.InsertWithOutputInto<TTarget, TOutput>(ITable<TTarget>, Expression<Func<TTarget>>, ITable<TOutput>, Expression<Func<TTarget, TOutput>>)

LinqExtensions.InsertWithOutputIntoAsync<TTarget, TOutput>(ITable<TTarget>, Expression<Func<TTarget>>, ITable<TOutput>, Expression<Func<TTarget, TOutput>>, CancellationToken)

LinqExtensions.LoadWithAsTable<T>(ITable<T>, Expression<Func<T, Nullable<Object>>>)

LinqExtensions.Merge<TTarget>(ITable<TTarget>)

LinqExtensions.Merge<TTarget>(ITable<TTarget>, String)

Sql.IsDistinctFrom<T>(T, T)

Sql.IsNotDistinctFrom<T>(T, T)

TableExtensions.IsTemporary<T>(ITable<T>, Boolean)

TableExtensions.IsTemporary<T>(ITable<T>)

TableExtensions.TableOptions<T>(ITable<T>, TableOptions)

TableExtensions.GetTableName<T>(ITable<T>)

DataConnectionExtensions.BulkCopy<T>(ITable<T>, BulkCopyOptions, IEnumerable<T>)

DataConnectionExtensions.BulkCopy<T>(ITable<T>, Int32, IEnumerable<T>)

DataConnectionExtensions.BulkCopy<T>(ITable<T>, IEnumerable<T>)

DataConnectionExtensions.BulkCopyAsync<T>(ITable<T>, BulkCopyOptions, IEnumerable<T>, CancellationToken)

DataConnectionExtensions.BulkCopyAsync<T>(ITable<T>, Int32, IEnumerable<T>, CancellationToken)

DataConnectionExtensions.BulkCopyAsync<T>(ITable<T>, IEnumerable<T>, CancellationToken)

SqlExtensions.In<T>(T, IEnumerable<T>)

SqlExtensions.In<T>(T, IQueryable<T>)

SqlExtensions.In<T>(T, T[])

SqlExtensions.In<T>(T, T, T)

SqlExtensions.In<T>(T, T, T, T)

SqlExtensions.NotIn<T>(T, IEnumerable<T>)

SqlExtensions.NotIn<T>(T, IQueryable<T>)

SqlExtensions.NotIn<T>(T, T[])

SqlExtensions.NotIn<T>(T, T, T)

SqlExtensions.NotIn<T>(T, T, T, T)

AccessTools.AsAccess<TSource>(ITable<TSource>)

MySqlTools.AsMySql<TSource>(ITable<TSource>)

OracleTools.AsOracle<TSource>(ITable<TSource>)

SqlServerTools.AsSqlCe<TSource>(ITable<TSource>)

SQLiteTools.AsSQLite<TSource>(ITable<TSource>)

SqlServerTools.AsSqlServer<TSource>(ITable<TSource>)