Welcome  |  Sign in
Skip Navigation Links
.NET Framework Developer Center
Click to Rate and Give Feedback
MSDN
MSDN Library
.NET Development
.NET Framework 3.5
SqlBulkCopy Class
 SqlBulkCopy Members
Members FilterMembers Filter
Frameworks FilterFrameworks Filter
This page is specific to
Microsoft Visual Studio 2008/.NET Framework 3.5

Other versions are also available for the following:
.NET Framework Class Library
SqlBulkCopy Members

Updated: November 2007

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

The SqlBulkCopy type exposes the following members.

  NameDescription
SqlBulkCopyOverloaded. Initializes a new instance of the SqlBulkCopy class.
Top
  NameDescription
Close Closes the SqlBulkCopy instance.
Equals Determines whether the specified Object is equal to the current Object. (Inherited from Object.)
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.)
GetHashCode Serves as a hash function for a particular type. (Inherited from Object.)
GetType Gets the Type of the current instance. (Inherited from Object.)
MemberwiseClone Creates a shallow copy of the current Object. (Inherited from Object.)
ToString Returns a String that represents the current Object. (Inherited from Object.)
WriteToServerOverloaded. Copies all rows from a data source to a destination table specified by the DestinationTableName property of the SqlBulkCopy object.
Top
  NameDescription
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.
Top
  NameDescription
SqlRowsCopied Occurs every time that the number of rows specified by the NotifyAfter property have been processed.
Top
  NameDescription
IDisposable..::.Dispose Releases all resources used by the current instance of the SqlBulkCopy class.
Top
Tags What's this?: Add a tag
Community Content   What is Community Content?
Add new content RSS  Annotations
Processing
© 2008 Microsoft Corporation. All rights reserved. Terms of Use  |  Trademarks  |  Privacy Statement
Page view tracker