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.
|BatchSize||Number of rows in each batch. At the end of each batch, the rows in the batch are sent to the server.|
|BulkCopyTimeout||Number of seconds for the operation to complete before it times out.|
|ColumnMappings||Returns a collection of SqlBulkCopyColumnMapping items. Column mappings define the relationships between columns in the data source and columns in the destination.|
|DestinationTableName||Name of the destination table on the server.|
|NotifyAfter||Defines the number of rows to be processed before generating a notification event.|
(see also Protected Methods )
|Close||Closes the SqlBulkCopy instance.|
|Equals||Overloaded. Determines whether two Object instances are equal. (Inherited from Object.)|
|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.)|
|GetType||Gets the Type of the current instance. (Inherited from Object.)|
|ReferenceEquals||Determines whether the specified Object instances are the same instance. (Inherited from Object.)|
|ToString||Returns a String that represents the current Object. (Inherited from Object.)|
|WriteToServer||Overloaded. Copies all rows from a data source to a destination table specified by the DestinationTableName property of the SqlBulkCopy object.|