BulkCopyOptions

E937656

BulkCopyOptions is an enumeration in ADO.NET that specifies configuration flags controlling the behavior and performance characteristics of SQL bulk copy operations.

All labels observed (4)

How this entity was disambiguated

Statements (44)

Predicate Object
instanceOf ADO.NET enumeration
enumeration
allowsCombination true
appliesTo SQL Server
category data access API
database performance tuning
defaultValue Default
definedIn System.Data.dll
linked to: System.Data
documentation Microsoft .NET API reference for System.Data.SqlClient.SqlBulkCopyOptions
hasFlagAttribute true
isFlagsEnum true
language C#
VB.NET
linked to: Visual Basic .NET
member AllowEncryptedValueModifications
CheckConstraints
Default
FireTriggers
KeepIdentity
KeepNulls
TableLock
UseInternalTransaction
memberSemantic AllowEncryptedValueModifications allows bulk copy of encrypted values without decryption
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
UseInternalTransaction wraps the bulk copy in an internal transaction
partOf System.Data.SqlClient namespace
platform .NET 5+
linked to: .NET (5 and later)

.NET Core
.NET Framework
purpose configure performance characteristics of bulk copy
control behavior of SQL Server bulk copy operations
relatedTo SqlBulkCopy class
linked to: SqlBulkCopy

SqlBulkCopyOptions in System.Data.SqlClient
linked to: BulkCopyOptions
scope controls server-side behavior of bulk insert
targetFrameworkAPI System.Data.SqlClient.SqlBulkCopyOptions
linked to: BulkCopyOptions
threadSafety enum values are immutable
usedIn SqlBulkCopy
usedWith SqlBulkCopy.BatchSize
linked to: SqlBulkCopy

SqlBulkCopy.BulkCopyTimeout
SqlBulkCopy.DestinationTableName

How these facts were elicited

Referenced by (4)

Full triples — surface form annotated when it differs from this entity's canonical label.

SqlBulkCopy hasProperty BulkCopyOptions
SqlBulkCopy usesOptionEnum SqlBulkCopyOptions
linked to: BulkCopyOptions
BulkCopyOptions targetFrameworkAPI System.Data.SqlClient.SqlBulkCopyOptions
linked to: BulkCopyOptions
BulkCopyOptions relatedTo SqlBulkCopyOptions in System.Data.SqlClient
linked to: BulkCopyOptions