Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 » SQL Anywhere Server - Programming » SQL Anywhere Data Access APIs » SQL Anywhere .NET 2.0 API reference » iAnywhere.Data.SQLAnywhere namespace (.NET 2.0) » SABulkCopy class


SABulkCopy members

Public constructors
Member name Description

SABulkCopy constructors

Initializes an SABulkCopy object.

Public properties
Member name Description

BatchSize property

Gets or sets the number of rows in each batch. At the end of each batch, the rows in the batch are sent to the server.

BulkCopyTimeout property

Gets or sets the number of seconds for the operation to complete before it times out.

ColumnMappings property

Returns a collection of SABulkCopyColumnMapping items. Column mappings define the relationships between columns in the data source and columns in the destination.

DestinationTableName property

Gets or sets the name of the destination table on the server.

NotifyAfter property

Gets or sets the number of rows to be processed before generating a notification event.

Public methods
Member name Description

Close method

Closes the SABulkCopy instance.

Dispose method

Disposes of the SABulkCopy instance.

WriteToServer methods

Copies all rows in the supplied array of [external link] DataRow objects to a destination table specified by the DestinationTableName property of the SABulkCopy object.

Public events
Member name Description

SARowsCopied event

This event occurs every time the number of rows specified by the NotifyAfter property have been processed.

See also