Class BasicBulkCopy

Inheritance
object
BasicBulkCopy
Namespace: LinqToDB.DataProvider
Assembly: linq2db.dll
Syntax
public class BasicBulkCopy

Properties

| Improve this Doc View Source

CastAllRowsParametersOnUnionAll

Declaration
protected virtual bool CastAllRowsParametersOnUnionAll { get; }
Property Value
Type Description
bool
| Improve this Doc View Source

CastFirstRowLiteralOnUnionAll

Declaration
protected virtual bool CastFirstRowLiteralOnUnionAll { get; }
Property Value
Type Description
bool
| Improve this Doc View Source

CastFirstRowParametersOnUnionAll

Declaration
protected virtual bool CastFirstRowParametersOnUnionAll { get; }
Property Value
Type Description
bool
| Improve this Doc View Source

MaxParameters

Declaration
protected virtual int MaxParameters { get; }
Property Value
Type Description
int
| Improve this Doc View Source

MaxSqlLength

Declaration
protected virtual int MaxSqlLength { get; }
Property Value
Type Description
int

Methods

| Improve this Doc View Source

BulkCopy<T>(BulkCopyType, ITable<T>, DataOptions, IEnumerable<T>)

Declaration
public virtual BulkCopyRowsCopied BulkCopy<T>(BulkCopyType bulkCopyType, ITable<T> table, DataOptions options, IEnumerable<T> source) where T : notnull
Parameters
Type Name Description
BulkCopyType bulkCopyType
ITable<T> table
DataOptions options
IEnumerable<T> source
Returns
Type Description
BulkCopyRowsCopied
Type Parameters
Name Description
T
| Improve this Doc View Source

BulkCopyAsync<T>(BulkCopyType, ITable<T>, DataOptions, IEnumerable<T>, CancellationToken)

Declaration
public virtual Task<BulkCopyRowsCopied> BulkCopyAsync<T>(BulkCopyType bulkCopyType, ITable<T> table, DataOptions options, IEnumerable<T> source, CancellationToken cancellationToken) where T : notnull
Parameters
Type Name Description
BulkCopyType bulkCopyType
ITable<T> table
DataOptions options
IEnumerable<T> source
CancellationToken cancellationToken
Returns
Type Description
Task<BulkCopyRowsCopied>
Type Parameters
Name Description
T
| Improve this Doc View Source

CastLiteral(ColumnDescriptor)

Declaration
protected virtual bool CastLiteral(ColumnDescriptor column)
Parameters
Type Name Description
ColumnDescriptor column
Returns
Type Description
bool
| Improve this Doc View Source

GetTableName<T>(ISqlBuilder, BulkCopyOptions, ITable<T>, bool)

Declaration
protected static string GetTableName<T>(ISqlBuilder sqlBuilder, BulkCopyOptions options, ITable<T> table, bool escaped = true) where T : notnull
Parameters
Type Name Description
ISqlBuilder sqlBuilder
BulkCopyOptions options
ITable<T> table
bool escaped
Returns
Type Description
string
Type Parameters
Name Description
T
| Improve this Doc View Source

MultipleRowsCopy<T>(ITable<T>, DataOptions, IEnumerable<T>)

Declaration
protected virtual BulkCopyRowsCopied MultipleRowsCopy<T>(ITable<T> table, DataOptions options, IEnumerable<T> source) where T : notnull
Parameters
Type Name Description
ITable<T> table
DataOptions options
IEnumerable<T> source
Returns
Type Description
BulkCopyRowsCopied
Type Parameters
Name Description
T
| Improve this Doc View Source

MultipleRowsCopy1(MultipleRowsHelper, IEnumerable)

Declaration
protected BulkCopyRowsCopied MultipleRowsCopy1(MultipleRowsHelper helper, IEnumerable source)
Parameters
Type Name Description
MultipleRowsHelper helper
IEnumerable source
Returns
Type Description
BulkCopyRowsCopied
| Improve this Doc View Source

MultipleRowsCopy1<T>(ITable<T>, DataOptions, IEnumerable<T>)

Declaration
protected BulkCopyRowsCopied MultipleRowsCopy1<T>(ITable<T> table, DataOptions options, IEnumerable<T> source) where T : notnull
Parameters
Type Name Description
ITable<T> table
DataOptions options
IEnumerable<T> source
Returns
Type Description
BulkCopyRowsCopied
Type Parameters
Name Description
T
| Improve this Doc View Source

MultipleRowsCopy1Async(MultipleRowsHelper, IEnumerable, CancellationToken)

Declaration
protected Task<BulkCopyRowsCopied> MultipleRowsCopy1Async(MultipleRowsHelper helper, IEnumerable source, CancellationToken cancellationToken)
Parameters
Type Name Description
MultipleRowsHelper helper
IEnumerable source
CancellationToken cancellationToken
Returns
Type Description
Task<BulkCopyRowsCopied>
| Improve this Doc View Source

MultipleRowsCopy1Async<T>(ITable<T>, DataOptions, IEnumerable<T>, CancellationToken)

Declaration
protected Task<BulkCopyRowsCopied> MultipleRowsCopy1Async<T>(ITable<T> table, DataOptions options, IEnumerable<T> source, CancellationToken cancellationToken) where T : notnull
Parameters
Type Name Description
ITable<T> table
DataOptions options
IEnumerable<T> source
CancellationToken cancellationToken
Returns
Type Description
Task<BulkCopyRowsCopied>
Type Parameters
Name Description
T
| Improve this Doc View Source

MultipleRowsCopy2(MultipleRowsHelper, IEnumerable, string)

Declaration
protected BulkCopyRowsCopied MultipleRowsCopy2(MultipleRowsHelper helper, IEnumerable source, string from)
Parameters
Type Name Description
MultipleRowsHelper helper
IEnumerable source
string from
Returns
Type Description
BulkCopyRowsCopied
| Improve this Doc View Source

MultipleRowsCopy2<T>(ITable<T>, DataOptions, IEnumerable<T>, string)

Declaration
protected BulkCopyRowsCopied MultipleRowsCopy2<T>(ITable<T> table, DataOptions options, IEnumerable<T> source, string from) where T : notnull
Parameters
Type Name Description
ITable<T> table
DataOptions options
IEnumerable<T> source
string from
Returns
Type Description
BulkCopyRowsCopied
Type Parameters
Name Description
T
| Improve this Doc View Source

MultipleRowsCopy2Async(MultipleRowsHelper, IEnumerable, string, CancellationToken)

Declaration
protected Task<BulkCopyRowsCopied> MultipleRowsCopy2Async(MultipleRowsHelper helper, IEnumerable source, string from, CancellationToken cancellationToken)
Parameters
Type Name Description
MultipleRowsHelper helper
IEnumerable source
string from
CancellationToken cancellationToken
Returns
Type Description
Task<BulkCopyRowsCopied>
| Improve this Doc View Source

MultipleRowsCopy2Async<T>(ITable<T>, DataOptions, IEnumerable<T>, string, CancellationToken)

Declaration
protected Task<BulkCopyRowsCopied> MultipleRowsCopy2Async<T>(ITable<T> table, DataOptions options, IEnumerable<T> source, string from, CancellationToken cancellationToken) where T : notnull
Parameters
Type Name Description
ITable<T> table
DataOptions options
IEnumerable<T> source
string from
CancellationToken cancellationToken
Returns
Type Description
Task<BulkCopyRowsCopied>
Type Parameters
Name Description
T
| Improve this Doc View Source

MultipleRowsCopy3(MultipleRowsHelper, BulkCopyOptions, IEnumerable, string)

Declaration
protected BulkCopyRowsCopied MultipleRowsCopy3(MultipleRowsHelper helper, BulkCopyOptions options, IEnumerable source, string from)
Parameters
Type Name Description
MultipleRowsHelper helper
BulkCopyOptions options
IEnumerable source
string from
Returns
Type Description
BulkCopyRowsCopied
| Improve this Doc View Source

MultipleRowsCopy3Async(MultipleRowsHelper, BulkCopyOptions, IEnumerable, string, CancellationToken)

Declaration
protected Task<BulkCopyRowsCopied> MultipleRowsCopy3Async(MultipleRowsHelper helper, BulkCopyOptions options, IEnumerable source, string from, CancellationToken cancellationToken)
Parameters
Type Name Description
MultipleRowsHelper helper
BulkCopyOptions options
IEnumerable source
string from
CancellationToken cancellationToken
Returns
Type Description
Task<BulkCopyRowsCopied>
| Improve this Doc View Source

MultipleRowsCopyAsync<T>(ITable<T>, DataOptions, IEnumerable<T>, CancellationToken)

Declaration
protected virtual Task<BulkCopyRowsCopied> MultipleRowsCopyAsync<T>(ITable<T> table, DataOptions options, IEnumerable<T> source, CancellationToken cancellationToken) where T : notnull
Parameters
Type Name Description
ITable<T> table
DataOptions options
IEnumerable<T> source
CancellationToken cancellationToken
Returns
Type Description
Task<BulkCopyRowsCopied>
Type Parameters
Name Description
T
| Improve this Doc View Source

MultipleRowsCopyHelper(MultipleRowsHelper, IEnumerable, string?, Action<MultipleRowsHelper>, Action<MultipleRowsHelper, object, string?>, Action<MultipleRowsHelper>, int, int)

Declaration
protected static BulkCopyRowsCopied MultipleRowsCopyHelper(MultipleRowsHelper helper, IEnumerable source, string? from, Action<MultipleRowsHelper> prepFunction, Action<MultipleRowsHelper, object, string?> addFunction, Action<MultipleRowsHelper> finishFunction, int maxParameters, int maxSqlLength)
Parameters
Type Name Description
MultipleRowsHelper helper
IEnumerable source
string from
Action<MultipleRowsHelper> prepFunction
Action<MultipleRowsHelper, object, string> addFunction
Action<MultipleRowsHelper> finishFunction
int maxParameters
int maxSqlLength
Returns
Type Description
BulkCopyRowsCopied
| Improve this Doc View Source

MultipleRowsCopyHelperAsync(MultipleRowsHelper, IEnumerable, string?, Action<MultipleRowsHelper>, Action<MultipleRowsHelper, object, string?>, Action<MultipleRowsHelper>, CancellationToken, int, int)

Declaration
protected static Task<BulkCopyRowsCopied> MultipleRowsCopyHelperAsync(MultipleRowsHelper helper, IEnumerable source, string? from, Action<MultipleRowsHelper> prepFunction, Action<MultipleRowsHelper, object, string?> addFunction, Action<MultipleRowsHelper> finishFunction, CancellationToken cancellationToken, int maxParameters, int maxSqlLength)
Parameters
Type Name Description
MultipleRowsHelper helper
IEnumerable source
string from
Action<MultipleRowsHelper> prepFunction
Action<MultipleRowsHelper, object, string> addFunction
Action<MultipleRowsHelper> finishFunction
CancellationToken cancellationToken
int maxParameters
int maxSqlLength
Returns
Type Description
Task<BulkCopyRowsCopied>
| Improve this Doc View Source

ProviderSpecificCopy<T>(ITable<T>, DataOptions, IEnumerable<T>)

Declaration
protected virtual BulkCopyRowsCopied ProviderSpecificCopy<T>(ITable<T> table, DataOptions options, IEnumerable<T> source) where T : notnull
Parameters
Type Name Description
ITable<T> table
DataOptions options
IEnumerable<T> source
Returns
Type Description
BulkCopyRowsCopied
Type Parameters
Name Description
T
| Improve this Doc View Source

ProviderSpecificCopyAsync<T>(ITable<T>, DataOptions, IEnumerable<T>, CancellationToken)

Declaration
protected virtual Task<BulkCopyRowsCopied> ProviderSpecificCopyAsync<T>(ITable<T> table, DataOptions options, IEnumerable<T> source, CancellationToken cancellationToken) where T : notnull
Parameters
Type Name Description
ITable<T> table
DataOptions options
IEnumerable<T> source
CancellationToken cancellationToken
Returns
Type Description
Task<BulkCopyRowsCopied>
Type Parameters
Name Description
T
| Improve this Doc View Source

RowByRowCopy<T>(ITable<T>, DataOptions, IEnumerable<T>)

Declaration
protected virtual BulkCopyRowsCopied RowByRowCopy<T>(ITable<T> table, DataOptions dataOptions, IEnumerable<T> source) where T : notnull
Parameters
Type Name Description
ITable<T> table
DataOptions dataOptions
IEnumerable<T> source
Returns
Type Description
BulkCopyRowsCopied
Type Parameters
Name Description
T
| Improve this Doc View Source

RowByRowCopyAsync<T>(ITable<T>, DataOptions, IEnumerable<T>, CancellationToken)

Declaration
protected virtual Task<BulkCopyRowsCopied> RowByRowCopyAsync<T>(ITable<T> table, DataOptions dataOptions, IEnumerable<T> source, CancellationToken cancellationToken) where T : notnull
Parameters
Type Name Description
ITable<T> table
DataOptions dataOptions
IEnumerable<T> source
CancellationToken cancellationToken
Returns
Type Description
Task<BulkCopyRowsCopied>
Type Parameters
Name Description
T
| Improve this Doc View Source

TraceAction(DataConnection, Func<string>, Func<int>)

Declaration
protected void TraceAction(DataConnection dataConnection, Func<string> commandText, Func<int> action)
Parameters
Type Name Description
DataConnection dataConnection
Func<string> commandText
Func<int> action
| Improve this Doc View Source

TraceActionAsync(DataConnection, Func<string>, Func<Task<int>>)

Declaration
protected Task TraceActionAsync(DataConnection dataConnection, Func<string> commandText, Func<Task<int>> action)
Parameters
Type Name Description
DataConnection dataConnection
Func<string> commandText
Func<Task<int>> action
Returns
Type Description
Task

Extension Methods