SqlRowsCopiedEventArgs::Abort Property


The .NET API Reference documentation has a new home. Visit the .NET API Browser on docs.microsoft.com to see the new experience.

Gets or sets a value that indicates whether the bulk copy operation should be aborted.

Namespace:   System.Data.SqlClient
Assembly:  System.Data (in System.Data.dll)

property bool Abort {
	bool get();
	void set(bool value);

Property Value

Type: System::Boolean

true if the bulk copy operation should be aborted; otherwise false.

Use the Abort property to cancel a bulk copy operation. Set Abort to true to abort the bulk copy operation.

If you call the Close method from SqlRowsCopied, an exception is generated, and the SqlBulkCopy object state does not change.

If an application specifically creates a SqlTransaction object in the SqlCommand constructor, the transaction is not rolled back. The application is responsible for determining whether it is required to rollback the operation, and if so, it must call the SqlTransaction::Rollback method. If the application does not create a transaction, the internal transaction corresponding to the current batch is automatically rolled back. However, changes related to previous batches within the bulk copy operation are retained, because the transactions for them already have been committed.

.NET Framework
Available since 2.0
Return to top