SqlBulkCopy.WriteToServerAsync Method (IDataReader)

.NET Framework (current version)
 

The asynchronous version of WriteToServer, which copies all rows in the supplied IDataReader to a destination table specified by the DestinationTableName property of the SqlBulkCopy object.

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

public Task WriteToServerAsync(
	IDataReader reader
)

Parameters

reader
Type: System.Data.IDataReader

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

Return Value

Type: System.Threading.Tasks.Task

A task representing the asynchronous operation.

Exception Condition
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.

The IDataReader was closed before the completed Task returned.

The IDataReader's associated connection was closed before the completed Task returned.

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
Available since 4.5
Return to top
Show: