SqlRowsCopiedEventArgs.Abort Property

Definition

Namespace:

System.Data.SqlClient

Assembly:

System.Data.SqlClient.dll

Package:

System.Data.SqlClient v4.8.6

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

public:
 property bool Abort { bool get(); void set(bool value); };

public bool Abort { get; set; }

member this.Abort : bool with get, set

Public Property Abort As Boolean

Property Value

Boolean

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

Remarks

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.

See also

• ADO.NET Overview