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 (6)

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 (7)

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
BulkCopyOptions → usedIn → SqlBulkCopy ⓘ
BulkCopyOptions → usedWith → SqlBulkCopy.BatchSize ⓘ
linked to: SqlBulkCopy
BulkCopyOptions → relatedTo → SqlBulkCopy class ⓘ
linked to: SqlBulkCopy