This documentation is archived and is not being maintained.

SqlBulkCopy Members

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

The SqlBulkCopy type exposes the following members.

  NameDescription
Public method SqlBulkCopy Overloaded. Initializes a new instance of the SqlBulkCopy class.
Top

  NameDescription
Public method Close Closes the SqlBulkCopy instance.
Public method Equals Determines whether the specified Object is equal to the current Object. (Inherited from Object.)
Protected method Finalize Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.)
Public method GetHashCode Serves as a hash function for a particular type. (Inherited from Object.)
Public method GetType Gets the type of the current instance. (Inherited from Object.)
Protected method MemberwiseClone Creates a shallow copy of the current Object. (Inherited from Object.)
Public method ToString Returns a string that represents the current object. (Inherited from Object.)
Public method WriteToServer Overloaded. Copies all rows from a data source to a destination table specified by the DestinationTableName property of the SqlBulkCopy object.
Top

  NameDescription
Public property BatchSize Number of rows in each batch. At the end of each batch, the rows in the batch are sent to the server.
Public property BulkCopyTimeout Number of seconds for the operation to complete before it times out.
Public property ColumnMappings Returns a collection of SqlBulkCopyColumnMapping items. Column mappings define the relationships between columns in the data source and columns in the destination.
Public property DestinationTableName Name of the destination table on the server.
Public property NotifyAfter Defines the number of rows to be processed before generating a notification event.
Top

  NameDescription
Public event SqlRowsCopied Occurs every time that the number of rows specified by the NotifyAfter property have been processed.
Top

  NameDescription
Explicit interface implemetation Private method IDisposable.Dispose Releases all resources used by the current instance of the SqlBulkCopy class.
Top
Show: