Class BulkCopyOptions

Defines behavior of BulkCopy<T>(DataConnection, BulkCopyOptions, IEnumerable<T>) method.

Inheritance
Object
BulkCopyOptions
Namespace: LinqToDB.Data
Assembly: linq2db.dll
Syntax
public class BulkCopyOptions

Constructors

| Improve this Doc View Source

BulkCopyOptions()

Declaration
public BulkCopyOptions()
| Improve this Doc View Source

BulkCopyOptions(BulkCopyOptions)

Declaration
public BulkCopyOptions(BulkCopyOptions options)
Parameters
Type Name Description
BulkCopyOptions options

Properties

| Improve this Doc View Source

BulkCopyTimeout

Declaration
public int? BulkCopyTimeout { get; set; }
Property Value
Type Description
Nullable<Int32>
| Improve this Doc View Source

BulkCopyType

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

CheckConstraints

Declaration
public bool? CheckConstraints { get; set; }
Property Value
Type Description
Nullable<Boolean>
| Improve this Doc View Source

DatabaseName

Gets or sets explicit name of target database instead of one, configured for copied entity in mapping schema. See DatabaseName<T>(ITable<T>, String) method for support information per provider.

Declaration
public string DatabaseName { get; set; }
Property Value
Type Description
String
| Improve this Doc View Source

FireTriggers

Declaration
public bool? FireTriggers { get; set; }
Property Value
Type Description
Nullable<Boolean>
| Improve this Doc View Source

IgnoreSkipOnInsert

Declaration
[Obsolete]
public bool? IgnoreSkipOnInsert { get; set; }
Property Value
Type Description
Nullable<Boolean>
| Improve this Doc View Source

KeepIdentity

If this option set to true, bulk copy will use values of columns, marked with IsIdentity flag. SkipOnInsert flag in this case will be ignored. Otherwise those columns will be skipped and values will be generated by server. Not compatible with RowByRow mode.

Declaration
public bool? KeepIdentity { get; set; }
Property Value
Type Description
Nullable<Boolean>
| Improve this Doc View Source

KeepNulls

Declaration
public bool? KeepNulls { get; set; }
Property Value
Type Description
Nullable<Boolean>
| Improve this Doc View Source

MaxBatchSize

Number of rows in each batch. At the end of each batch, the rows in the batch are sent to the server.

Declaration
public int? MaxBatchSize { get; set; }
Property Value
Type Description
Nullable<Int32>

The integer value of the MaxBatchSize property, or zero if no value has been set.
| Improve this Doc View Source

NotifyAfter

Gets or sets counter after how many copied records RowsCopiedCallback should be called. E.g. if you set it to 10, callback will be called after each 10 copied records. To disable callback, set this option to 0 (default value).

Declaration
public int NotifyAfter { get; set; }
Property Value
Type Description
Int32
| Improve this Doc View Source

RetrieveSequence

Declaration
[Obsolete("Use the Tools.RetrieveIdentity method instead.")]
public bool RetrieveSequence { get; set; }
Property Value
Type Description
Boolean
| Improve this Doc View Source

RowsCopiedCallback

Gets or sets callback method that will be called by BulkCopy operation after each NotifyAfter rows copied. This callback will not be used if NotifyAfter set to 0.

Declaration
public Action<BulkCopyRowsCopied> RowsCopiedCallback { get; set; }
Property Value
Type Description
Action<BulkCopyRowsCopied>
| Improve this Doc View Source

SchemaName

Gets or sets explicit name of target schema/owner instead of one, configured for copied entity in mapping schema. See SchemaName<T>(ITable<T>, String) method for support information per provider.

Declaration
public string SchemaName { get; set; }
Property Value
Type Description
String
| Improve this Doc View Source

ServerName

Gets or sets explicit name of target server instead of one, configured for copied entity in mapping schema. See ServerName<T>(ITable<T>, String) method for support information per provider. Also note that it is not supported by provider-specific insert method.

Declaration
public string ServerName { get; set; }
Property Value
Type Description
String
| Improve this Doc View Source

TableLock

Declaration
public bool? TableLock { get; set; }
Property Value
Type Description
Nullable<Boolean>
| Improve this Doc View Source

TableName

Gets or sets explicit name of target table instead of one, configured for copied entity in mapping schema.

Declaration
public string TableName { get; set; }
Property Value
Type Description
String
| Improve this Doc View Source

UseInternalTransaction

Declaration
public bool? UseInternalTransaction { get; set; }
Property Value
Type Description
Nullable<Boolean>

Extension Methods