.NET Framework Class Library
SqlBulkCopy Members

Lets you efficiently bulk load a SQL Server table with data from another source.

The SqlBulkCopy type exposes the following members.

Constructors

  NameDescription
Public methodSqlBulkCopyOverloaded. Initializes a new instance of the SqlBulkCopy class.
Top
Methods

  NameDescription
Public methodCloseCloses the SqlBulkCopy instance.
Public methodEqualsDetermines whether the specified Object is equal to the current Object. (Inherited from Object.)
Protected methodFinalizeAllows an Object to attempt to free resources and perform other cleanup operations before the Object is reclaimed by garbage collection. (Inherited from Object.)
Public methodGetHashCodeServes as a hash function for a particular type. (Inherited from Object.)
Public methodGetTypeGets the Type of the current instance. (Inherited from Object.)
Protected methodMemberwiseCloneCreates a shallow copy of the current Object. (Inherited from Object.)
Public methodToStringReturns a String that represents the current Object. (Inherited from Object.)
Public methodWriteToServerOverloaded. Copies all rows from a data source to a destination table specified by the DestinationTableName property of the SqlBulkCopy object.
Top
Properties

  NameDescription
Public propertyBatchSizeNumber of rows in each batch. At the end of each batch, the rows in the batch are sent to the server.
Public propertyBulkCopyTimeoutNumber of seconds for the operation to complete before it times out.
Public propertyColumnMappingsReturns a collection of SqlBulkCopyColumnMapping items. Column mappings define the relationships between columns in the data source and columns in the destination.
Public propertyDestinationTableNameName of the destination table on the server.
Public propertyNotifyAfterDefines the number of rows to be processed before generating a notification event.
Top
Events

  NameDescription
Public eventSqlRowsCopiedOccurs every time that the number of rows specified by the NotifyAfter property have been processed.
Top
Explicit Interface Implementations

  NameDescription
Explicit interface implemetationPrivate methodIDisposable..::.DisposeReleases all resources used by the current instance of the SqlBulkCopy class.
Top
See Also

Reference

Tags :


Page view tracker