SqlBulkCopy

E277027

SqlBulkCopy is a .NET class that enables high-performance bulk data transfer operations from various data sources into SQL Server tables.

All labels observed (4)

How this entity was disambiguated

Statements (50)

Predicate Object
instanceOf .NET class
ADO.NET component
data access API
bypasses row-by-row insert commands
canUseTransaction SqlTransaction
hasConstructor SqlBulkCopy(SqlConnection)
linked to: SqlBulkCopy

SqlBulkCopy(SqlConnection, SqlBulkCopyOptions, SqlTransaction)
linked to: SqlBulkCopy

SqlBulkCopy(string connectionString)
SqlBulkCopy(string connectionString, SqlBulkCopyOptions options)
hasEvent SqlRowsCopied
linked to: SqlBulkCopy
hasMethod Close()
Dispose()
WriteToServer(DataRow[])
WriteToServer(DataTable)
WriteToServer(IDataReader)
WriteToServerAsync(DataRow[])
WriteToServerAsync(DataTable)
WriteToServerAsync(IDataReader)
hasProperty BatchSize
BulkCopyOptions
BulkCopyTimeout
ColumnMappings
DestinationTableName
EnableStreaming
NotifyAfter
SqlRowsCopied
implementsInterface IDisposable
introducedIn .NET Framework 2.0
linked to: .NET Framework
namespace System.Data.SqlClient
optimizes large volume inserts
partOf .NET 5+
linked to: .NET 5

.NET Core
.NET Framework
primaryPurpose high-performance bulk data transfer into SQL Server
requires valid SQL Server connection
supportsFeature batching of rows
column mapping between source and destination
progress notifications
streaming from IDataReader
timeout configuration
supportsSource DataRow[]
DataTable
linked to: TTable

DbDataReader
IDataReader
supportsTarget Azure SQL Database
Microsoft SQL Server
linked to: SQL Server
typicalUseCase ETL operations into SQL Server
loading data from files via DataTable or IDataReader
migrating data between databases
usesOptionEnum SqlBulkCopyOptions
linked to: BulkCopyOptions

How these facts were elicited

Referenced by (4)

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

SqlBulkCopy hasConstructor SqlBulkCopy(SqlConnection)
linked to: SqlBulkCopy
SqlBulkCopy hasConstructor SqlBulkCopy(SqlConnection, SqlBulkCopyOptions, SqlTransaction)
linked to: SqlBulkCopy
SqlBulkCopy hasEvent SqlRowsCopied
linked to: SqlBulkCopy