BulkCopyOptions
E937656
BulkCopyOptions is an enumeration in ADO.NET that specifies configuration flags controlling the behavior and performance characteristics of SQL bulk copy operations.
Observed surface forms (1)
| Surface form | Occurrences |
|---|---|
| SqlBulkCopyOptions | 1 |
Statements (44)
| Predicate | Object |
|---|---|
| instanceOf |
ADO.NET enumeration
ⓘ
enumeration ⓘ |
| allowsCombination | true ⓘ |
| appliesTo | SQL Server NERFINISHED ⓘ |
| category |
data access API
ⓘ
database performance tuning ⓘ |
| defaultValue | Default ⓘ |
| definedIn | System.Data.dll NERFINISHED ⓘ |
| documentation | Microsoft .NET API reference for System.Data.SqlClient.SqlBulkCopyOptions ⓘ |
| hasFlagAttribute | true ⓘ |
| isFlagsEnum | true ⓘ |
| language |
C#
NERFINISHED
ⓘ
VB.NET NERFINISHED ⓘ |
| member |
AllowEncryptedValueModifications
ⓘ
CheckConstraints ⓘ Default ⓘ FireTriggers ⓘ KeepIdentity ⓘ KeepNulls ⓘ TableLock ⓘ UseInternalTransaction ⓘ |
| memberSemantic |
AllowEncryptedValueModifications allows bulk copy of encrypted values without decryption
NERFINISHED
ⓘ
CheckConstraints checks constraints during bulk insert ⓘ Default uses standard bulk copy behavior ⓘ FireTriggers fires insert triggers on the destination table ⓘ KeepIdentity preserves source identity values during bulk copy ⓘ KeepNulls preserves null values instead of using column defaults ⓘ TableLock acquires a bulk update lock on the destination table NERFINISHED ⓘ UseInternalTransaction wraps the bulk copy in an internal transaction ⓘ |
| partOf | System.Data.SqlClient namespace NERFINISHED ⓘ |
| platform |
.NET 5+
NERFINISHED
ⓘ
.NET Core NERFINISHED ⓘ .NET Framework NERFINISHED ⓘ |
| purpose |
configure performance characteristics of bulk copy
ⓘ
control behavior of SQL Server bulk copy operations ⓘ |
| relatedTo |
SqlBulkCopy class
NERFINISHED
ⓘ
SqlBulkCopyOptions in System.Data.SqlClient NERFINISHED ⓘ |
| scope | controls server-side behavior of bulk insert ⓘ |
| targetFrameworkAPI | System.Data.SqlClient.SqlBulkCopyOptions NERFINISHED ⓘ |
| threadSafety | enum values are immutable ⓘ |
| usedIn | SqlBulkCopy NERFINISHED ⓘ |
| usedWith |
SqlBulkCopy.BatchSize
NERFINISHED
ⓘ
SqlBulkCopy.BulkCopyTimeout ⓘ SqlBulkCopy.DestinationTableName NERFINISHED ⓘ |
Referenced by (2)
Full triples — surface form annotated when it differs from this entity's canonical label.
this entity surface form:
SqlBulkCopyOptions