Export (0) Print
Expand All

SqlBulkCopy Members

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

The following tables list the members exposed by the SqlBulkCopy type.

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

  Name Description
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

(see also Protected Methods )
  Name Description
Public method Close Closes the SqlBulkCopy instance.
Public method Equals  Overloaded. Determines whether two Object instances are equal. (Inherited from Object.)
Public method GetHashCode  Serves as a hash function for a particular type. GetHashCode is suitable for use in hashing algorithms and data structures like a hash table. (Inherited from Object.)
Public method GetType  Gets the Type of the current instance. (Inherited from Object.)
Public method Static ReferenceEquals  Determines whether the specified Object instances are the same instance. (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

  Name Description
Protected method Finalize  Allows an Object to attempt to free resources and perform other cleanup operations before the Object is reclaimed by garbage collection. (Inherited from Object.)
Protected method MemberwiseClone  Creates a shallow copy of the current Object. (Inherited from Object.)
Top

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

  Name Description
Explicit interface implementation Method System.IDisposable.Dispose Closes the SqlBulkCopy instance.
Top

Community Additions

ADD
Show:
© 2015 Microsoft