Upgrade your Internet Experience
Microsoft.com
Welcome Sign in
.NET Framework Developer Center
Click to Rate and Give Feedback
MSDN
MSDN Library
.NET Development
.NET Framework 3.5
SqlBulkCopy Class
 SqlBulkCopy Members

  Switch on low bandwidth view
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

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

The SqlBulkCopy type exposes the following members.

  NameDescription
Public methodSqlBulkCopyOverloaded. Initializes a new instance of the SqlBulkCopy class.
Top
  NameDescription
Public methodClose Closes the SqlBulkCopy instance.
Public methodEquals Determines whether the specified Object is equal to the current Object. (Inherited from Object.)
Protected methodFinalize Allows an Object to attempt to free resources and perform other cleanup operations before the Object is reclaimed by garbage collection. (Inherited from Object.)
Public methodGetHashCode Serves as a hash function for a particular type. (Inherited from Object.)
Public methodGetType Gets the Type of the current instance. (Inherited from Object.)
Protected methodMemberwiseClone Creates a shallow copy of the current Object. (Inherited from Object.)
Public methodToString Returns 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
  NameDescription
Public propertyBatchSize Number of rows in each batch. At the end of each batch, the rows in the batch are sent to the server.
Public propertyBulkCopyTimeout Number of seconds for the operation to complete before it times out.
Public propertyColumnMappings Returns a collection of SqlBulkCopyColumnMapping items. Column mappings define the relationships between columns in the data source and columns in the destination.
Public propertyDestinationTableName Name of the destination table on the server.
Public propertyNotifyAfter Defines the number of rows to be processed before generating a notification event.
Top
  NameDescription
Public eventSqlRowsCopied Occurs every time that the number of rows specified by the NotifyAfter property have been processed.
Top
  NameDescription
Explicit interface implemetationPrivate methodIDisposable..::.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
© 2009 Microsoft Corporation. All rights reserved. Terms of Use  |  Trademarks  |  Privacy Statement
Page view tracker