SqlPipe.ExecuteAndSend Method (SqlCommand)
Executes the command passed as a parameter and sends the results to the client.
Assembly: System.Data (in System.Data.dll)
In addition to any actual results, other messages and errors are also sent directly to the client.
Output parameters and return values are not sent to the client; these are available to the caller, through the parameters collection of the command object.
If the command is not bound to an in-process connection, an InvalidOperationException is thrown. This method is not supported on commands bound to out-of-process connections.
If there are errors in the SqlCommand object that was submitted, exceptions are sent to the pipe, but a copy is also sent to calling managed code. If the calling code doesn't catch the exception, it will propagate up the stack to the Transact-SQL code and appear in the output twice. If the calling code does catch the exception, the pipe consumer will still see the error, but there will not be a duplicate error.
Available since 2.0