SqlBulkCopy.WriteToServerAsync Method (DataTable, DataRowState, CancellationToken)

.NET Framework 4.5

The asynchronous version of WriteToServer, which copies only rows that match the supplied row state in the supplied DataTable to a destination table specified by the DestinationTableName property of the SqlBulkCopy object.

The cancellation token can be used to request that the operation be abandoned before the command timeout elapses. Exceptions will be reported via the returned Task object.

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

public Task WriteToServerAsync(
	DataTable table,
	DataRowState rowState,
	CancellationToken cancellationToken
)

Parameters

table
Type: System.Data.DataTable

A DataTable whose rows will be copied to the destination table.

rowState
Type: System.Data.DataRowState

A value from the DataRowState enumeration. Only rows matching the row state are copied to the destination.

cancellationToken
Type: System.Threading.CancellationToken

The cancellation instruction. A None value in this parameter makes this method equivalent to WriteToServerAsync.

Return Value

Type: System.Threading.Tasks.Task
A task representing the asynchronous operation.

ExceptionCondition
InvalidOperationException

Calling WriteToServerAsync multiple times for the same instance before task completion.

Calling WriteToServerAsync and WriteToServer for the same instance before task completion.

The connection drops or is closed during WriteToServerAsync execution.

Returned in the task object, the SqlBulkCopy object was closed during the method execution.

Returned in the task object, there was a connection pool timeout.

Returned in the task object, the SqlConnection object is closed before method execution.

Context Connection=true is specified in the connection string.

SqlException

Returned in the task object, any error returned by SQL Server that occurred while opening the connection.

For more information about asynchronous programming in the .NET Framework Data Provider for SQL Server, see Asynchronous Programming.

.NET Framework

Supported in: 4.5.2, 4.5.1, 4.5

Windows 8.1, Windows Server 2012 R2, Windows 8, Windows Server 2012, Windows 7, Windows Vista SP2, Windows Server 2008 (Server Core Role not supported), Windows Server 2008 R2 (Server Core Role supported with SP1 or later; Itanium not supported)

The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft