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 self-linksurface differs
surface form: SqlBulkCopy(SqlConnection)

SqlBulkCopy self-linksurface differs
surface form: SqlBulkCopy(SqlConnection, SqlBulkCopyOptions, SqlTransaction)

SqlBulkCopy(string connectionString)
SqlBulkCopy(string connectionString, SqlBulkCopyOptions options)
hasEvent SqlBulkCopy self-linksurface differs
surface form: SqlRowsCopied
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
surface form: .NET Framework 2.0
namespace .NET Data Provider for SQL Server
surface form: System.Data.SqlClient
optimizes large volume inserts
partOf .NET 5
surface form: .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[]
TTable
surface form: DataTable

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

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 self-linksurface differs
this entity surface form: SqlBulkCopy(SqlConnection)
SqlBulkCopy hasConstructor SqlBulkCopy self-linksurface differs
this entity surface form: SqlBulkCopy(SqlConnection, SqlBulkCopyOptions, SqlTransaction)
SqlBulkCopy hasEvent SqlBulkCopy self-linksurface differs
this entity surface form: SqlRowsCopied