Class BulkCopyOptions
Defines behavior of method.
Inheritance
System.Object
BulkCopyOptions
Assembly: linq2db.dll
Syntax
public class BulkCopyOptions : object
Constructors
|
Improve this Doc
View Source
BulkCopyOptions()
Declaration
|
Improve this Doc
View Source
BulkCopyOptions(BulkCopyOptions)
Declaration
public BulkCopyOptions(BulkCopyOptions options)
Parameters
Properties
|
Improve this Doc
View Source
BulkCopyTimeout
Declaration
public int? BulkCopyTimeout { get; set; }
Property Value
Type |
Description |
System.Nullable<System.Int32> |
|
|
Improve this Doc
View Source
BulkCopyType
Declaration
public BulkCopyType BulkCopyType { get; set; }
Property Value
|
Improve this Doc
View Source
CheckConstraints
Declaration
public bool? CheckConstraints { get; set; }
Property Value
Type |
Description |
System.Nullable<System.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 method for support information per provider.
Declaration
public string? DatabaseName { get; set; }
Property Value
Type |
Description |
System.Nullable<System.String> |
|
|
Improve this Doc
View Source
FireTriggers
Declaration
public bool? FireTriggers { get; set; }
Property Value
Type |
Description |
System.Nullable<System.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 |
System.Nullable<System.Boolean> |
|
|
Improve this Doc
View Source
KeepNulls
Declaration
public bool? KeepNulls { get; set; }
Property Value
Type |
Description |
System.Nullable<System.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 |
System.Nullable<System.Int32> |
The integer value of the MaxBatchSize property, or zero if no value has been set.
|
|
Improve this Doc
View Source
MaxParametersForBatch
If set, will override the Maximum parameters per batch statement from MaxParameters.
Declaration
public int? MaxParametersForBatch { get; set; }
Property Value
Type |
Description |
System.Nullable<System.Int32> |
|
|
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 |
System.Int32 |
|
|
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
|
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 method for support information per provider.
Declaration
public string? SchemaName { get; set; }
Property Value
Type |
Description |
System.Nullable<System.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 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 |
System.Nullable<System.String> |
|
|
Improve this Doc
View Source
TableLock
Declaration
public bool? TableLock { get; set; }
Property Value
Type |
Description |
System.Nullable<System.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 |
System.Nullable<System.String> |
|
|
Improve this Doc
View Source
TableOptions
Declaration
public TableOptions TableOptions { get; set; }
Property Value
|
Improve this Doc
View Source
UseInternalTransaction
Declaration
public bool? UseInternalTransaction { get; set; }
Property Value
Type |
Description |
System.Nullable<System.Boolean> |
|
|
Improve this Doc
View Source
UseParameters
Gets or sets whether to Always use Parameters for MultipleRowsCopy. Default is false.
If True, provider's override for MaxParameters will be used to determine the maximum number of rows per insert,
Unless overridden by MaxParametersForBatch.
Declaration
public bool UseParameters { get; set; }
Property Value
Type |
Description |
System.Boolean |
|
Extension Methods