Class TempTable<T>

Namespace

LinqToDB

Assembly

linq2db.dll

Temporary table. Temporary table is a table, created when you create instance of this class and deleted when you dispose it. It uses regular tables even if underlying database supports temporary tables concept.

public class TempTable<T> : ITable<T>, IExpressionQuery<T>, IOrderedQueryable<T>, IQueryable<T>, IEnumerable<T>, IOrderedQueryable, IQueryable, IEnumerable, IQueryProviderAsync, IQueryProvider, IExpressionQuery, ITableMutable<T>, IDisposable, IAsyncDisposable where T : notnull

Type Parameters

T

Table record mapping class.

Inheritance

object

TempTable<T>

Implements

ITable<T>

IExpressionQuery<T>

IOrderedQueryable<T>

IQueryable<T>

IEnumerable<T>

IOrderedQueryable

IQueryable

IEnumerable

IQueryProviderAsync

IQueryProvider

IExpressionQuery

ITableMutable<T>

IDisposable

IAsyncDisposable

Extension Methods

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

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

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

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

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

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

DataExtensions.DropTableAsync<T>(ITable<T>, string?, string?, string?, bool?, string?, TableOptions, CancellationToken)

DataExtensions.DropTable<T>(ITable<T>, string?, string?, string?, bool?, string?, TableOptions)

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

ClickHouseTools.AsClickHouse<TSource>(ITable<TSource>)

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

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

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

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

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

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

LinqExtensions.DatabaseName<T>(ITable<T>, string?)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

LinqExtensions.LoadWithAsTable<T>(ITable<T>, Expression<Func<T, object?>>)

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

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

LinqExtensions.SchemaName<T>(ITable<T>, string?)

LinqExtensions.ServerName<T>(ITable<T>, string?)

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

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

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

LinqExtensions.TableID<T>(ITable<T>, string?)

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

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

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

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

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.WithTableExpression<T>(ITable<T>, string)

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

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

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

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

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

Sql.IsDistinctFrom<T>(T, T)

Sql.IsNotDistinctFrom<T>(T, T)

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

AnalyticFunctions.Average<TEntity, TV>(IEnumerable<TEntity>, Func<TEntity, TV>, Sql.AggregateModifier)

AnalyticFunctions.Corr<T>(IEnumerable<T>, Expression<Func<T, object?>>, Expression<Func<T, object?>>)

AnalyticFunctions.CountExt<TEntity>(IEnumerable<TEntity>, Func<TEntity, object?>)

AnalyticFunctions.CountExt<TEntity, TV>(IEnumerable<TEntity>, Func<TEntity, TV>, Sql.AggregateModifier)

AnalyticFunctions.CovarPop<T>(IEnumerable<T>, Expression<Func<T, object?>>, Expression<Func<T, object?>>)

AnalyticFunctions.CovarSamp<T>(IEnumerable<T>, Expression<Func<T, object?>>, Expression<Func<T, object?>>)

AnalyticFunctions.LongCountExt<TEntity>(IEnumerable<TEntity>, Func<TEntity, object?>)

AnalyticFunctions.LongCountExt<TEntity, TV>(IEnumerable<TEntity>, Func<TEntity, TV>, Sql.AggregateModifier)

AnalyticFunctions.Max<TEntity, TV>(IEnumerable<TEntity>, Func<TEntity, TV>, Sql.AggregateModifier)

AnalyticFunctions.Median<TEntity, T>(IEnumerable<TEntity>, Func<TEntity, T>)

AnalyticFunctions.Min<TEntity, TV>(IEnumerable<TEntity>, Func<TEntity, TV>, Sql.AggregateModifier)

AnalyticFunctions.StdDevPop<TEntity, TV>(IEnumerable<TEntity>, Func<TEntity, TV>)

AnalyticFunctions.StdDevSamp<TEntity, TV>(IEnumerable<TEntity>, Func<TEntity, TV>)

AnalyticFunctions.StdDev<TEntity, TV>(IEnumerable<TEntity>, Func<TEntity, TV>)

AnalyticFunctions.StdDev<TEntity, TV>(IEnumerable<TEntity>, Func<TEntity, TV>, Sql.AggregateModifier)

AnalyticFunctions.VarPop<TEntity, TV>(IEnumerable<TEntity>, Func<TEntity, TV>)

AnalyticFunctions.VarSamp<TEntity, TV>(IEnumerable<TEntity>, Func<TEntity, TV>)

AnalyticFunctions.Variance<TEntity, TV>(IEnumerable<TEntity>, Func<TEntity, TV>)

AnalyticFunctions.Variance<TEntity, TV>(IEnumerable<TEntity>, Func<TEntity, TV>, Sql.AggregateModifier)

PostgreSQLExtensions.ArrayAggregate<TEntity, TV>(IEnumerable<TEntity>, Func<TEntity, TV>, Sql.AggregateModifier)

LinqExtensions.AsQueryable<TElement>(IEnumerable<TElement>, IDataContext)

Sql.StringAggregate<T>(IEnumerable<T>, string, Func<T, string?>)

DataExtensions.RetrieveIdentity<T>(IEnumerable<T>, DataConnection, bool, bool)

ReflectionExtensions.GetListItemType(IEnumerable?)

AnalyticFunctions.Average<TEntity, TV>(IQueryable<TEntity>, Expression<Func<TEntity, TV>>, Sql.AggregateModifier)

AnalyticFunctions.Corr<TEntity>(IQueryable<TEntity>, Expression<Func<TEntity, object?>>, Expression<Func<TEntity, object?>>)

AnalyticFunctions.CountExt<TEntity, TV>(IQueryable<TEntity>, Expression<Func<TEntity, TV>>)

AnalyticFunctions.CountExt<TEntity, TV>(IQueryable<TEntity>, Expression<Func<TEntity, TV>>, Sql.AggregateModifier)

AnalyticFunctions.CovarPop<TEntity>(IQueryable<TEntity>, Expression<Func<TEntity, object?>>, Expression<Func<TEntity, object?>>)

AnalyticFunctions.CovarSamp<TEntity>(IQueryable<TEntity>, Expression<Func<TEntity, object?>>, Expression<Func<TEntity, object?>>)

AnalyticFunctions.LongCountExt<TEntity, TV>(IQueryable<TEntity>, Expression<Func<TEntity, TV>>, Sql.AggregateModifier)

AnalyticFunctions.Max<TEntity, TV>(IQueryable<TEntity>, Expression<Func<TEntity, TV>>, Sql.AggregateModifier)

AnalyticFunctions.Median<TEntity, TV>(IQueryable<TEntity>, Expression<Func<TEntity, TV>>)

AnalyticFunctions.Min<TEntity, TV>(IQueryable<TEntity>, Expression<Func<TEntity, TV>>, Sql.AggregateModifier)

AnalyticFunctions.StdDevPop<TEntity, TV>(IQueryable<TEntity>, Expression<Func<TEntity, TV>>)

AnalyticFunctions.StdDevSamp<TEntity, TV>(IQueryable<TEntity>, Expression<Func<TEntity, TV>>)

AnalyticFunctions.StdDev<TEntity, TV>(IQueryable<TEntity>, Expression<Func<TEntity, TV>>, Sql.AggregateModifier)

AnalyticFunctions.VarPop<TEntity, TV>(IQueryable<TEntity>, Expression<Func<TEntity, TV>>)

AnalyticFunctions.VarSamp<TEntity, TV>(IQueryable<TEntity>, Expression<Func<TEntity, TV>>)

AnalyticFunctions.Variance<TEntity, TV>(IQueryable<TEntity>, Expression<Func<TEntity, TV>>, Sql.AggregateModifier)

AsyncExtensions.AllAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, bool>>, CancellationToken)

AsyncExtensions.AnyAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, bool>>, CancellationToken)

AsyncExtensions.AnyAsync<TSource>(IQueryable<TSource>, CancellationToken)

AsyncExtensions.AsAsyncEnumerable<TSource>(IQueryable<TSource>)

AsyncExtensions.AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, decimal>>, CancellationToken)

AsyncExtensions.AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, double>>, CancellationToken)

AsyncExtensions.AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, int>>, CancellationToken)

AsyncExtensions.AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, long>>, CancellationToken)

AsyncExtensions.AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, decimal?>>, CancellationToken)

AsyncExtensions.AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, double?>>, CancellationToken)

AsyncExtensions.AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, int?>>, CancellationToken)

AsyncExtensions.AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, long?>>, CancellationToken)

AsyncExtensions.AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, float?>>, CancellationToken)

AsyncExtensions.AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, float>>, CancellationToken)

AsyncExtensions.ContainsAsync<TSource>(IQueryable<TSource>, TSource, CancellationToken)

AsyncExtensions.CountAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, bool>>, CancellationToken)

AsyncExtensions.CountAsync<TSource>(IQueryable<TSource>, CancellationToken)

AsyncExtensions.FirstAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, bool>>, CancellationToken)

AsyncExtensions.FirstAsync<TSource>(IQueryable<TSource>, CancellationToken)

AsyncExtensions.FirstOrDefaultAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, bool>>, CancellationToken)

AsyncExtensions.FirstOrDefaultAsync<TSource>(IQueryable<TSource>, CancellationToken)

AsyncExtensions.ForEachAsync<TSource>(IQueryable<TSource>, Action<TSource>, CancellationToken)

AsyncExtensions.ForEachUntilAsync<TSource>(IQueryable<TSource>, Func<TSource, bool>, CancellationToken)

AsyncExtensions.LongCountAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, bool>>, CancellationToken)

AsyncExtensions.LongCountAsync<TSource>(IQueryable<TSource>, CancellationToken)

AsyncExtensions.MaxAsync<TSource>(IQueryable<TSource>, CancellationToken)

AsyncExtensions.MaxAsync<TSource, TResult>(IQueryable<TSource>, Expression<Func<TSource, TResult>>, CancellationToken)

AsyncExtensions.MinAsync<TSource>(IQueryable<TSource>, CancellationToken)

AsyncExtensions.MinAsync<TSource, TResult>(IQueryable<TSource>, Expression<Func<TSource, TResult>>, CancellationToken)

AsyncExtensions.SingleAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, bool>>, CancellationToken)

AsyncExtensions.SingleAsync<TSource>(IQueryable<TSource>, CancellationToken)

AsyncExtensions.SingleOrDefaultAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, bool>>, CancellationToken)

AsyncExtensions.SingleOrDefaultAsync<TSource>(IQueryable<TSource>, CancellationToken)

AsyncExtensions.SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, decimal>>, CancellationToken)

AsyncExtensions.SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, double>>, CancellationToken)

AsyncExtensions.SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, int>>, CancellationToken)

AsyncExtensions.SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, long>>, CancellationToken)

AsyncExtensions.SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, decimal?>>, CancellationToken)

AsyncExtensions.SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, double?>>, CancellationToken)

AsyncExtensions.SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, int?>>, CancellationToken)

AsyncExtensions.SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, long?>>, CancellationToken)

AsyncExtensions.SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, float?>>, CancellationToken)

AsyncExtensions.SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource, float>>, CancellationToken)

AsyncExtensions.ToArrayAsync<TSource>(IQueryable<TSource>, CancellationToken)

AsyncExtensions.ToDictionaryAsync<TSource, TKey>(IQueryable<TSource>, Func<TSource, TKey>, IEqualityComparer<TKey>, CancellationToken)

AsyncExtensions.ToDictionaryAsync<TSource, TKey>(IQueryable<TSource>, Func<TSource, TKey>, CancellationToken)

AsyncExtensions.ToDictionaryAsync<TSource, TKey, TElement>(IQueryable<TSource>, Func<TSource, TKey>, Func<TSource, TElement>, IEqualityComparer<TKey>, CancellationToken)

AsyncExtensions.ToDictionaryAsync<TSource, TKey, TElement>(IQueryable<TSource>, Func<TSource, TKey>, Func<TSource, TElement>, CancellationToken)

AsyncExtensions.ToListAsync<TSource>(IQueryable<TSource>, CancellationToken)

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

ClickHouseTools.AsClickHouse<TSource>(IQueryable<TSource>)

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

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

PostgreSQLExtensions.ArrayAggregate<TEntity, TV>(IQueryable<TEntity>, Expression<Func<TEntity, TV>>)

PostgreSQLExtensions.ArrayAggregate<TEntity, TV>(IQueryable<TEntity>, Expression<Func<TEntity, TV>>, Sql.AggregateModifier)

PostgreSQLTools.AsPostgreSQL<TSource>(IQueryable<TSource>)

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

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

LinqExtensions.AsCte<TSource>(IQueryable<TSource>)

LinqExtensions.AsCte<TSource>(IQueryable<TSource>, string?)

LinqExtensions.AsSubQuery<TSource>(IQueryable<TSource>)

LinqExtensions.AsSubQuery<TSource>(IQueryable<TSource>, string)

LinqExtensions.AsUpdatable<T>(IQueryable<T>)

LinqExtensions.CrossJoin<TOuter, TInner, TResult>(IQueryable<TOuter>, IQueryable<TInner>, Expression<Func<TOuter, TInner, TResult>>)

LinqExtensions.DeleteAsync<T>(IQueryable<T>, Expression<Func<T, bool>>, CancellationToken)

LinqExtensions.DeleteAsync<T>(IQueryable<T>, CancellationToken)

LinqExtensions.DeleteWithOutputAsync<TSource>(IQueryable<TSource>, CancellationToken)

LinqExtensions.DeleteWithOutputAsync<TSource, TOutput>(IQueryable<TSource>, Expression<Func<TSource, TOutput>>, CancellationToken)

LinqExtensions.DeleteWithOutputIntoAsync<TSource, TOutput>(IQueryable<TSource>, ITable<TOutput>, Expression<Func<TSource, TOutput>>, CancellationToken)

LinqExtensions.DeleteWithOutputIntoAsync<TSource, TOutput>(IQueryable<TSource>, ITable<TOutput>, CancellationToken)

LinqExtensions.DeleteWithOutputInto<TSource, TOutput>(IQueryable<TSource>, ITable<TOutput>)

LinqExtensions.DeleteWithOutputInto<TSource, TOutput>(IQueryable<TSource>, ITable<TOutput>, Expression<Func<TSource, TOutput>>)

LinqExtensions.DeleteWithOutput<TSource>(IQueryable<TSource>)

LinqExtensions.DeleteWithOutput<TSource, TOutput>(IQueryable<TSource>, Expression<Func<TSource, TOutput>>)

LinqExtensions.Delete<T>(IQueryable<T>)

LinqExtensions.Delete<T>(IQueryable<T>, Expression<Func<T, bool>>)

LinqExtensions.ElementAtAsync<TSource>(IQueryable<TSource>, Expression<Func<int>>, CancellationToken)

LinqExtensions.ElementAtOrDefaultAsync<TSource>(IQueryable<TSource>, Expression<Func<int>>, CancellationToken)

LinqExtensions.ElementAtOrDefault<TSource>(IQueryable<TSource>, Expression<Func<int>>)

LinqExtensions.ElementAt<TSource>(IQueryable<TSource>, Expression<Func<int>>)

LinqExtensions.ExceptAll<TSource>(IQueryable<TSource>, IEnumerable<TSource>)

LinqExtensions.FullJoin<TSource>(IQueryable<TSource>, Expression<Func<TSource, bool>>)

LinqExtensions.FullJoin<TOuter, TInner, TResult>(IQueryable<TOuter>, IQueryable<TInner>, Expression<Func<TOuter, TInner, bool>>, Expression<Func<TOuter, TInner, TResult>>)

LinqExtensions.GenerateTestString<T>(IQueryable<T>, bool)

LinqExtensions.HasUniqueKey<TSource, TKey>(IQueryable<TSource>, Expression<Func<TSource, TKey>>)

LinqExtensions.Having<TSource>(IQueryable<TSource>, Expression<Func<TSource, bool>>)

LinqExtensions.IgnoreFilters<TSource>(IQueryable<TSource>, params Type[])

LinqExtensions.InlineParameters<TSource>(IQueryable<TSource>)

LinqExtensions.InnerJoin<TSource>(IQueryable<TSource>, Expression<Func<TSource, bool>>)

LinqExtensions.InnerJoin<TOuter, TInner, TResult>(IQueryable<TOuter>, IQueryable<TInner>, Expression<Func<TOuter, TInner, bool>>, Expression<Func<TOuter, TInner, TResult>>)

LinqExtensions.InsertAsync<TSource, TTarget>(IQueryable<TSource>, ITable<TTarget>, Expression<Func<TSource, TTarget>>, CancellationToken)

LinqExtensions.InsertWithDecimalIdentityAsync<TSource, TTarget>(IQueryable<TSource>, ITable<TTarget>, Expression<Func<TSource, TTarget>>, CancellationToken)

LinqExtensions.InsertWithDecimalIdentity<TSource, TTarget>(IQueryable<TSource>, ITable<TTarget>, Expression<Func<TSource, TTarget>>)

LinqExtensions.InsertWithIdentityAsync<TSource, TTarget>(IQueryable<TSource>, ITable<TTarget>, Expression<Func<TSource, TTarget>>, CancellationToken)

LinqExtensions.InsertWithIdentity<TSource, TTarget>(IQueryable<TSource>, ITable<TTarget>, Expression<Func<TSource, TTarget>>)

LinqExtensions.InsertWithInt32IdentityAsync<TSource, TTarget>(IQueryable<TSource>, ITable<TTarget>, Expression<Func<TSource, TTarget>>, CancellationToken)

LinqExtensions.InsertWithInt32Identity<TSource, TTarget>(IQueryable<TSource>, ITable<TTarget>, Expression<Func<TSource, TTarget>>)

LinqExtensions.InsertWithInt64IdentityAsync<TSource, TTarget>(IQueryable<TSource>, ITable<TTarget>, Expression<Func<TSource, TTarget>>, CancellationToken)

LinqExtensions.InsertWithInt64Identity<TSource, TTarget>(IQueryable<TSource>, ITable<TTarget>, Expression<Func<TSource, TTarget>>)

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

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

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

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

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

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

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

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

LinqExtensions.Insert<TSource, TTarget>(IQueryable<TSource>, ITable<TTarget>, Expression<Func<TSource, TTarget>>)

LinqExtensions.IntersectAll<TSource>(IQueryable<TSource>, IEnumerable<TSource>)

LinqExtensions.Into<TSource, TTarget>(IQueryable<TSource>, ITable<TTarget>)

LinqExtensions.JoinHint<TSource>(IQueryable<TSource>, string)

LinqExtensions.Join<TSource>(IQueryable<TSource>, SqlJoinType, Expression<Func<TSource, bool>>)

LinqExtensions.Join<TOuter, TInner, TResult>(IQueryable<TOuter>, IQueryable<TInner>, SqlJoinType, Expression<Func<TOuter, TInner, bool>>, Expression<Func<TOuter, TInner, TResult>>)

LinqExtensions.LeftJoin<TSource>(IQueryable<TSource>, Expression<Func<TSource, bool>>)

LinqExtensions.LeftJoin<TOuter, TInner, TResult>(IQueryable<TOuter>, IQueryable<TInner>, Expression<Func<TOuter, TInner, bool>>, Expression<Func<TOuter, TInner, TResult>>)

LinqExtensions.MergeInto<TTarget, TSource>(IQueryable<TSource>, ITable<TTarget>)

LinqExtensions.MergeInto<TTarget, TSource>(IQueryable<TSource>, ITable<TTarget>, string)

LinqExtensions.MergeInto<TTarget, TSource>(IQueryable<TSource>, IQueryable<TTarget>)

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

LinqExtensions.QueryHint<TSource>(IQueryable<TSource>, string)

LinqExtensions.QueryHint<TSource, TParam>(IQueryable<TSource>, string, TParam)

LinqExtensions.QueryHint<TSource, TParam>(IQueryable<TSource>, string, params TParam[])

LinqExtensions.QueryName<TSource>(IQueryable<TSource>, string)

LinqExtensions.RemoveOrderBy<TSource>(IQueryable<TSource>)

LinqExtensions.RightJoin<TSource>(IQueryable<TSource>, Expression<Func<TSource, bool>>)

LinqExtensions.RightJoin<TOuter, TInner, TResult>(IQueryable<TOuter>, IQueryable<TInner>, Expression<Func<TOuter, TInner, bool>>, Expression<Func<TOuter, TInner, TResult>>)

LinqExtensions.Set<T>(IQueryable<T>, Expression<Func<T, string>>)

LinqExtensions.Set<T, TV>(IQueryable<T>, Expression<Func<T, TV>>, Expression<Func<TV>>)

LinqExtensions.Set<T, TV>(IQueryable<T>, Expression<Func<T, TV>>, Expression<Func<T, TV>>)

LinqExtensions.Set<T, TV>(IQueryable<T>, Expression<Func<T, TV>>, TV)

LinqExtensions.Skip<TSource>(IQueryable<TSource>, Expression<Func<int>>)

LinqExtensions.SubQueryHint<TSource>(IQueryable<TSource>, string)

LinqExtensions.SubQueryHint<TSource, TParam>(IQueryable<TSource>, string, TParam)

LinqExtensions.SubQueryHint<TSource, TParam>(IQueryable<TSource>, string, params TParam[])

LinqExtensions.TablesInScopeHint<TSource>(IQueryable<TSource>, string)

LinqExtensions.TablesInScopeHint<TSource>(IQueryable<TSource>, string, params object[])

LinqExtensions.TablesInScopeHint<TSource, TParam>(IQueryable<TSource>, string, TParam)

LinqExtensions.TagQuery<TSource>(IQueryable<TSource>, string)

LinqExtensions.Take<TSource>(IQueryable<TSource>, int, TakeHints)

LinqExtensions.Take<TSource>(IQueryable<TSource>, Expression<Func<int>>)

LinqExtensions.Take<TSource>(IQueryable<TSource>, Expression<Func<int>>, TakeHints)

LinqExtensions.ThenOrByDescending<TSource, TKey>(IQueryable<TSource>, Expression<Func<TSource, TKey>>)

LinqExtensions.ThenOrBy<TSource, TKey>(IQueryable<TSource>, Expression<Func<TSource, TKey>>)

LinqExtensions.UnionAll<TSource>(IQueryable<TSource>, IEnumerable<TSource>)

LinqExtensions.UpdateAsync<T>(IQueryable<T>, Expression<Func<T, bool>>, Expression<Func<T, T>>, CancellationToken)

LinqExtensions.UpdateAsync<T>(IQueryable<T>, Expression<Func<T, T>>, CancellationToken)

LinqExtensions.UpdateAsync<TSource, TTarget>(IQueryable<TSource>, ITable<TTarget>, Expression<Func<TSource, TTarget>>, CancellationToken)

LinqExtensions.UpdateAsync<TSource, TTarget>(IQueryable<TSource>, Expression<Func<TSource, TTarget>>, Expression<Func<TSource, TTarget>>, CancellationToken)

LinqExtensions.UpdateWithOutputAsync<T>(IQueryable<T>, Expression<Func<T, T>>, CancellationToken)

LinqExtensions.UpdateWithOutputAsync<TSource, TTarget>(IQueryable<TSource>, ITable<TTarget>, Expression<Func<TSource, TTarget>>, CancellationToken)

LinqExtensions.UpdateWithOutputAsync<TSource, TTarget>(IQueryable<TSource>, Expression<Func<TSource, TTarget>>, Expression<Func<TSource, TTarget>>, CancellationToken)

LinqExtensions.UpdateWithOutputAsync<T, TOutput>(IQueryable<T>, Expression<Func<T, T>>, Expression<Func<T, T, TOutput>>, CancellationToken)

LinqExtensions.UpdateWithOutputAsync<TSource, TTarget, TOutput>(IQueryable<TSource>, ITable<TTarget>, Expression<Func<TSource, TTarget>>, Expression<Func<TSource, TTarget, TTarget, TOutput>>, CancellationToken)

LinqExtensions.UpdateWithOutputAsync<TSource, TTarget, TOutput>(IQueryable<TSource>, Expression<Func<TSource, TTarget>>, Expression<Func<TSource, TTarget>>, Expression<Func<TSource, TTarget, TTarget, TOutput>>, CancellationToken)

LinqExtensions.UpdateWithOutputIntoAsync<TSource, TTarget>(IQueryable<TSource>, ITable<TTarget>, Expression<Func<TSource, TTarget>>, ITable<TTarget>, CancellationToken)

LinqExtensions.UpdateWithOutputIntoAsync<TSource, TTarget>(IQueryable<TSource>, Expression<Func<TSource, TTarget>>, Expression<Func<TSource, TTarget>>, ITable<TTarget>, CancellationToken)

LinqExtensions.UpdateWithOutputIntoAsync<T, TOutput>(IQueryable<T>, Expression<Func<T, T>>, ITable<TOutput>, Expression<Func<T, T, TOutput>>, CancellationToken)

LinqExtensions.UpdateWithOutputIntoAsync<TSource, TTarget, TOutput>(IQueryable<TSource>, ITable<TTarget>, Expression<Func<TSource, TTarget>>, ITable<TOutput>, Expression<Func<TSource, TTarget, TTarget, TOutput>>, CancellationToken)

LinqExtensions.UpdateWithOutputIntoAsync<TSource, TTarget, TOutput>(IQueryable<TSource>, Expression<Func<TSource, TTarget>>, Expression<Func<TSource, TTarget>>, ITable<TOutput>, Expression<Func<TSource, TTarget, TTarget, TOutput>>, CancellationToken)

LinqExtensions.UpdateWithOutputInto<TSource, TTarget>(IQueryable<TSource>, ITable<TTarget>, Expression<Func<TSource, TTarget>>, ITable<TTarget>)

LinqExtensions.UpdateWithOutputInto<TSource, TTarget>(IQueryable<TSource>, Expression<Func<TSource, TTarget>>, Expression<Func<TSource, TTarget>>, ITable<TTarget>)

LinqExtensions.UpdateWithOutputInto<T, TOutput>(IQueryable<T>, Expression<Func<T, T>>, ITable<TOutput>, Expression<Func<T, T, TOutput>>)

LinqExtensions.UpdateWithOutputInto<TSource, TTarget, TOutput>(IQueryable<TSource>, ITable<TTarget>, Expression<Func<TSource, TTarget>>, ITable<TOutput>, Expression<Func<TSource, TTarget, TTarget, TOutput>>)

LinqExtensions.UpdateWithOutputInto<TSource, TTarget, TOutput>(IQueryable<TSource>, Expression<Func<TSource, TTarget>>, Expression<Func<TSource, TTarget>>, ITable<TOutput>, Expression<Func<TSource, TTarget, TTarget, TOutput>>)

LinqExtensions.UpdateWithOutput<T>(IQueryable<T>, Expression<Func<T, T>>)

LinqExtensions.UpdateWithOutput<TSource, TTarget>(IQueryable<TSource>, ITable<TTarget>, Expression<Func<TSource, TTarget>>)

LinqExtensions.UpdateWithOutput<TSource, TTarget>(IQueryable<TSource>, Expression<Func<TSource, TTarget>>, Expression<Func<TSource, TTarget>>)

LinqExtensions.UpdateWithOutput<T, TOutput>(IQueryable<T>, Expression<Func<T, T>>, Expression<Func<T, T, TOutput>>)

LinqExtensions.UpdateWithOutput<TSource, TTarget, TOutput>(IQueryable<TSource>, ITable<TTarget>, Expression<Func<TSource, TTarget>>, Expression<Func<TSource, TTarget, TTarget, TOutput>>)

LinqExtensions.UpdateWithOutput<TSource, TTarget, TOutput>(IQueryable<TSource>, Expression<Func<TSource, TTarget>>, Expression<Func<TSource, TTarget>>, Expression<Func<TSource, TTarget, TTarget, TOutput>>)

LinqExtensions.Update<T>(IQueryable<T>, Expression<Func<T, bool>>, Expression<Func<T, T>>)

LinqExtensions.Update<T>(IQueryable<T>, Expression<Func<T, T>>)

LinqExtensions.Update<TSource, TTarget>(IQueryable<TSource>, ITable<TTarget>, Expression<Func<TSource, TTarget>>)

LinqExtensions.Update<TSource, TTarget>(IQueryable<TSource>, Expression<Func<TSource, TTarget>>, Expression<Func<TSource, TTarget>>)

MultiInsertExtensions.MultiInsert<TSource>(IQueryable<TSource>)

Sql.StringAggregate<T>(IQueryable<T>, string, Expression<Func<T, string?>>)

Constructors

TempTable(IDataContext, IEnumerable<T>, BulkCopyOptions?, string?, string?, string?, string?, TableOptions)

Creates new temporary table and populate it using BulkCopy.

public TempTable(IDataContext db, IEnumerable<T> items, BulkCopyOptions? options = null, string? tableName = null, string? databaseName = null, string? schemaName = null, string? serverName = null, TableOptions tableOptions = TableOptions.NotSet)

Parameters

db IDataContext

Database connection instance.

items IEnumerable<T>

Initial records to insert into created table.

options BulkCopyOptions

Optional BulkCopy options.

tableName string

Optional name of temporary table. If not specified, value from mapping will be used.

databaseName string

Optional name of table's database. If not specified, value from mapping will be used.

schemaName string

Optional name of table schema/owner. If not specified, value from mapping will be used.

serverName string

Optional name of linked server. If not specified, value from mapping will be used.

tableOptions TableOptions

Optional Table options. If not specified, value from mapping will be used.

TempTable(IDataContext, IQueryable<T>, string?, string?, string?, Action<ITable<T>>?, string?, TableOptions)

Creates new temporary table and populate it using data from provided query.

public TempTable(IDataContext db, IQueryable<T> items, string? tableName = null, string? databaseName = null, string? schemaName = null, Action<ITable<T>>? action = null, string? serverName = null, TableOptions tableOptions = TableOptions.NotSet)

Parameters

db IDataContext

Database connection instance.

items IQueryable<T>

Query to get records to populate created table with initial data.

tableName string

Optional name of temporary table. If not specified, value from mapping will be used.

databaseName string

Optional name of table's database. If not specified, value from mapping will be used.

schemaName string

Optional name of table schema/owner. If not specified, value from mapping will be used.

action Action<ITable<T>>

Optional action that will be executed after table creation but before it populated with data from items.

serverName string

Optional name of linked server. If not specified, value from mapping will be used.

tableOptions TableOptions

Optional Table options. If not specified, value from mapping will be used.

TempTable(IDataContext, string?, IEnumerable<T>, BulkCopyOptions?, string?, string?, string?, TableOptions)

Creates new temporary table and populate it using BulkCopy.

public TempTable(IDataContext db, string? tableName, IEnumerable<T> items, BulkCopyOptions? options = null, string? databaseName = null, string? schemaName = null, string? serverName = null, TableOptions tableOptions = TableOptions.NotSet)

Parameters

db IDataContext

Database connection instance.

tableName string

Optional name of temporary table. If not specified, value from mapping will be used.

items IEnumerable<T>

Initial records to insert into created table.

options BulkCopyOptions

Optional BulkCopy options.

databaseName string

Optional name of table's database. If not specified, value from mapping will be used.

schemaName string

Optional name of table schema/owner. If not specified, value from mapping will be used.

serverName string

Optional name of linked server. If not specified, value from mapping will be used.

tableOptions TableOptions

Optional Table options. If not specified, value from mapping will be used.

TempTable(IDataContext, string?, IQueryable<T>, string?, string?, Action<ITable<T>>?, string?, TableOptions)

Creates new temporary table and populate it using data from provided query.

public TempTable(IDataContext db, string? tableName, IQueryable<T> items, string? databaseName = null, string? schemaName = null, Action<ITable<T>>? action = null, string? serverName = null, TableOptions tableOptions = TableOptions.NotSet)

Parameters

db IDataContext

Database connection instance.

tableName string

Optional name of temporary table. If not specified, value from mapping will be used.

items IQueryable<T>

Query to get records to populate created table with initial data.

databaseName string

Optional name of table's database. If not specified, value from mapping will be used.

schemaName string

Optional name of table schema/owner. If not specified, value from mapping will be used.

action Action<ITable<T>>

Optional action that will be executed after table creation but before it populated with data from items.

serverName string

Optional name of linked server. If not specified, value from mapping will be used.

tableOptions TableOptions

Optional Table options. If not specified, value from mapping will be used.

TempTable(IDataContext, string?, string?, string?, string?, TableOptions)

Creates new temporary table.

public TempTable(IDataContext db, string? tableName = null, string? databaseName = null, string? schemaName = null, string? serverName = null, TableOptions tableOptions = TableOptions.NotSet)

Parameters

db IDataContext

Database connection instance.

tableName string

Optional name of temporary table. If not specified, value from mapping will be used.

databaseName string

Optional name of table's database. If not specified, value from mapping will be used.

schemaName string

Optional name of table schema/owner. If not specified, value from mapping will be used.

serverName string

Optional name of linked server. If not specified, value from mapping will be used.

tableOptions TableOptions

Optional Table options. If not specified, value from mapping will be used.

TempTable(ITable<T>, EntityDescriptor?)

Configures a temporary table that will be dropped when this instance is disposed

protected TempTable(ITable<T> table, EntityDescriptor? tableDescriptor)

Parameters

table ITable<T>

Table instance.

tableDescriptor EntityDescriptor

Temporary table entity descriptor.

Fields

TotalCopied

Gets total number of records, inserted into table using BulkCopy.

public long TotalCopied

Field Value

long

Properties

DataContext

Gets data connection, associated with current table.

public IDataContext DataContext { get; }

Property Value

IDataContext

DatabaseName

public string? DatabaseName { get; }

Property Value

string

SchemaName

public string? SchemaName { get; }

Property Value

string

ServerName

public string? ServerName { get; }

Property Value

string

TableID

public string? TableID { get; }

Property Value

string

TableName

public string TableName { get; }

Property Value

string

TableOptions

public TableOptions TableOptions { get; }

Property Value

TableOptions

Methods

Copy(IEnumerable<T>, BulkCopyOptions?)

Insert new records into table using BulkCopy.

public long Copy(IEnumerable<T> items, BulkCopyOptions? options = null)

Parameters

items IEnumerable<T>

Records to insert into table.

options BulkCopyOptions

Optional BulkCopy options.

Returns

long

Number of records, inserted into table.

CopyAsync(IEnumerable<T>, BulkCopyOptions?, CancellationToken)

Insert new records into table using BulkCopy.

public Task<long> CopyAsync(IEnumerable<T> items, BulkCopyOptions? options = null, CancellationToken cancellationToken = default)

Parameters

items IEnumerable<T>

Records to insert into table.

options BulkCopyOptions

Optional BulkCopy options.

cancellationToken CancellationToken

Asynchronous operation cancellation token.

Returns

Task<long>

Number of records, inserted into table.

CreateAsync(IDataContext, IEnumerable<T>, BulkCopyOptions?, string?, string?, string?, string?, TableOptions, CancellationToken)

Creates new temporary table and populate it using BulkCopy.

public static Task<TempTable<T>> CreateAsync(IDataContext db, IEnumerable<T> items, BulkCopyOptions? options = null, string? tableName = null, string? databaseName = null, string? schemaName = null, string? serverName = null, TableOptions tableOptions = TableOptions.NotSet, CancellationToken cancellationToken = default)

Parameters

db IDataContext

Database connection instance.

items IEnumerable<T>

Initial records to insert into created table.

options BulkCopyOptions

Optional BulkCopy options.

tableName string

Optional name of temporary table. If not specified, value from mapping will be used.

databaseName string

Optional name of table's database. If not specified, value from mapping will be used.

schemaName string

Optional name of table schema/owner. If not specified, value from mapping will be used.

serverName string

Optional name of linked server. If not specified, value from mapping will be used.

tableOptions TableOptions

Optional Table options. If not specified, value from mapping will be used.

cancellationToken CancellationToken

Asynchronous operation cancellation token.

Returns

Task<TempTable<T>>

CreateAsync(IDataContext, IQueryable<T>, string?, string?, string?, Func<ITable<T>, Task>?, string?, TableOptions, CancellationToken)

Creates new temporary table and populate it using data from provided query.

public static Task<TempTable<T>> CreateAsync(IDataContext db, IQueryable<T> items, string? tableName = null, string? databaseName = null, string? schemaName = null, Func<ITable<T>, Task>? action = null, string? serverName = null, TableOptions tableOptions = TableOptions.NotSet, CancellationToken cancellationToken = default)

Parameters

db IDataContext

Database connection instance.

items IQueryable<T>

Query to get records to populate created table with initial data.

tableName string

Optional name of temporary table. If not specified, value from mapping will be used.

databaseName string

Optional name of table's database. If not specified, value from mapping will be used.

schemaName string

Optional name of table schema/owner. If not specified, value from mapping will be used.

action Func<ITable<T>, Task>

Optional asynchronous action that will be executed after table creation but before it populated with data from items.

serverName string

Optional name of linked server. If not specified, value from mapping will be used.

tableOptions TableOptions

Optional Table options. If not specified, value from mapping will be used.

cancellationToken CancellationToken

Asynchronous operation cancellation token.

Returns

Task<TempTable<T>>

CreateAsync(IDataContext, string?, IEnumerable<T>, BulkCopyOptions?, string?, string?, string?, TableOptions, CancellationToken)

Creates new temporary table and populate it using BulkCopy.

public static Task<TempTable<T>> CreateAsync(IDataContext db, string? tableName, IEnumerable<T> items, BulkCopyOptions? options = null, string? databaseName = null, string? schemaName = null, string? serverName = null, TableOptions tableOptions = TableOptions.NotSet, CancellationToken cancellationToken = default)

Parameters

db IDataContext

Database connection instance.

tableName string

Optional name of temporary table. If not specified, value from mapping will be used.

items IEnumerable<T>

Initial records to insert into created table.

options BulkCopyOptions

Optional BulkCopy options.

databaseName string

Optional name of table's database. If not specified, value from mapping will be used.

schemaName string

Optional name of table schema/owner. If not specified, value from mapping will be used.

serverName string

Optional name of linked server. If not specified, value from mapping will be used.

tableOptions TableOptions

Optional Table options. If not specified, value from mapping will be used.

cancellationToken CancellationToken

Asynchronous operation cancellation token.

Returns

Task<TempTable<T>>

CreateAsync(IDataContext, string?, IQueryable<T>, string?, string?, Func<ITable<T>, Task>?, string?, TableOptions, CancellationToken)

Creates new temporary table and populate it using data from provided query.

public static Task<TempTable<T>> CreateAsync(IDataContext db, string? tableName, IQueryable<T> items, string? databaseName = null, string? schemaName = null, Func<ITable<T>, Task>? action = null, string? serverName = null, TableOptions tableOptions = TableOptions.NotSet, CancellationToken cancellationToken = default)

Parameters

db IDataContext

Database connection instance.

tableName string

Optional name of temporary table. If not specified, value from mapping will be used.

items IQueryable<T>

Query to get records to populate created table with initial data.

databaseName string

Optional name of table's database. If not specified, value from mapping will be used.

schemaName string

Optional name of table schema/owner. If not specified, value from mapping will be used.

action Func<ITable<T>, Task>

Optional asynchronous action that will be executed after table creation but before it populated with data from items.

serverName string

Optional name of linked server. If not specified, value from mapping will be used.

tableOptions TableOptions

Optional Table options. If not specified, value from mapping will be used.

cancellationToken CancellationToken

Asynchronous operation cancellation token.

Returns

Task<TempTable<T>>

CreateAsync(IDataContext, string?, string?, string?, string?, TableOptions, CancellationToken)

Creates new temporary table.

public static Task<TempTable<T>> CreateAsync(IDataContext db, string? tableName = null, string? databaseName = null, string? schemaName = null, string? serverName = null, TableOptions tableOptions = TableOptions.NotSet, CancellationToken cancellationToken = default)

Parameters

db IDataContext

Database connection instance.

tableName string

Optional name of temporary table. If not specified, value from mapping will be used.

databaseName string

Optional name of table's database. If not specified, value from mapping will be used.

schemaName string

Optional name of table schema/owner. If not specified, value from mapping will be used.

serverName string

Optional name of linked server. If not specified, value from mapping will be used.

tableOptions TableOptions

Optional Table options. If not specified, value from mapping will be used.

cancellationToken CancellationToken

Asynchronous operation cancellation token.

Returns

Task<TempTable<T>>

Dispose()

Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources.

public virtual void Dispose()

DisposeAsync()

Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources asynchronously.

public virtual Task DisposeAsync()

Returns

Task

Insert(IQueryable<T>)

Insert data into table using records, returned by provided query.

public long Insert(IQueryable<T> items)

Parameters

items IQueryable<T>

Query with records to insert into temporary table.

Returns

long

Number of records, inserted into table.

InsertAsync(IQueryable<T>, CancellationToken)

Insert data into table using records, returned by provided query.

public Task<long> InsertAsync(IQueryable<T> items, CancellationToken cancellationToken = default)

Parameters

items IQueryable<T>

Query with records to insert into temporary table.

cancellationToken CancellationToken

Asynchronous operation cancellation token.

Returns

Task<long>

Number of records, inserted into table.