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