SqlBulkCopy.IDisposable.Dispose Method

Definition

Namespace:

Microsoft.Data.SqlClient

Assembly:

Microsoft.Data.SqlClient.dll

Package:

Microsoft.Data.SqlClient v5.2.0

Releases all resources used by the current instance of the SqlBulkCopy class.

 virtual void System.IDisposable.Dispose() = IDisposable::Dispose;

void IDisposable.Dispose ();

abstract member System.IDisposable.Dispose : unit -> unit
override this.System.IDisposable.Dispose : unit -> unit

Sub Dispose () Implements IDisposable.Dispose

Implements

Dispose()

Remarks

Call Dispose when you are finished using the SqlBulkCopy. The Dispose method leaves the SqlBulkCopy in an unusable state. After calling Dispose, you must release all references to the SqlBulkCopy so the garbage collector can reclaim the memory that the SqlBulkCopy was occupying.

For more information, see Cleaning Up Unmanaged Resources and Implementing a Dispose Method.

Note

Always call Dispose before you release your last reference to the SqlBulkCopy. Otherwise, the resources it is using will not be freed until the garbage collector calls the SqlBulkCopy object's Finalize method.