.

####  Returns

[ IAsyncResult ](system.iasyncresult?view=dotnet-plat-ext-8.0)

An [ IAsyncResult ](system.iasyncresult?view=dotnet-plat-ext-8.0) that can be
used to poll, wait for results, or both; this value is also needed when the [
EndExecuteXmlReader(IAsyncResult)
](system.data.sqlclient.sqlcommand.endexecutexmlreader?view=dotnet-plat-
ext-8.0#system-data-sqlclient-sqlcommand-endexecutexmlreader\(system-
iasyncresult\)) is called, which returns the results of the command as XML.

####  Exceptions

[ InvalidCastException ](system.invalidcastexception?view=dotnet-plat-ext-8.0)

A [ SqlDbType ](system.data.sqlclient.sqlparameter.sqldbtype?view=dotnet-plat-
ext-8.0#system-data-sqlclient-sqlparameter-sqldbtype) other than **Binary** or
**VarBinary** was used when [ Value
](system.data.sqlclient.sqlparameter.value?view=dotnet-plat-ext-8.0#system-
data-sqlclient-sqlparameter-value) was set to [ Stream
](system.io.stream?view=dotnet-plat-ext-8.0) . For more information about
streaming, see [ SqlClient Streaming Support ](/en-
us/dotnet/framework/data/adonet/sqlclient-streaming-support) .

-or- 

A [ SqlDbType ](system.data.sqlclient.sqlparameter.sqldbtype?view=dotnet-plat-
ext-8.0#system-data-sqlclient-sqlparameter-sqldbtype) other than **Char** ,
**NChar** , **NVarChar** , **VarChar** , or **Xml** was used when [ Value
](system.data.sqlclient.sqlparameter.value?view=dotnet-plat-ext-8.0#system-
data-sqlclient-sqlparameter-value) was set to [ TextReader
](system.io.textreader?view=dotnet-plat-ext-8.0) .

-or- 

A [ SqlDbType ](system.data.sqlclient.sqlparameter.sqldbtype?view=dotnet-plat-
ext-8.0#system-data-sqlclient-sqlparameter-sqldbtype) other than **Xml** was
used when [ Value ](system.data.sqlclient.sqlparameter.value?view=dotnet-plat-
ext-8.0#system-data-sqlclient-sqlparameter-value) was set to [ XmlReader
](system.xml.xmlreader?view=dotnet-plat-ext-8.0) .

[ SqlException ](system.data.sqlclient.sqlexception?view=dotnet-plat-ext-8.0)

Any error that occurred while executing the command text.

-or- 

A timeout occurred during a streaming operation. For more information about
streaming, see [ SqlClient Streaming Support ](/en-
us/dotnet/framework/data/adonet/sqlclient-streaming-support) .

[ InvalidOperationException ](system.invalidoperationexception?view=dotnet-
plat-ext-8.0)

The name/value pair "Asynchronous Processing=true" was not included within the
connection string defining the connection for this [ SqlCommand
](system.data.sqlclient.sqlcommand?view=dotnet-plat-ext-8.0) .

-or- 

The [ SqlConnection ](system.data.sqlclient.sqlconnection?view=dotnet-plat-
ext-8.0) closed or dropped during a streaming operation. For more information
about streaming, see [ SqlClient Streaming Support ](/en-
us/dotnet/framework/data/adonet/sqlclient-streaming-support) .

[ IOException ](system.io.ioexception?view=dotnet-plat-ext-8.0)

An error occurred in a [ Stream ](system.io.stream?view=dotnet-plat-ext-8.0) ,
[ XmlReader ](system.xml.xmlreader?view=dotnet-plat-ext-8.0) or [ TextReader
](system.io.textreader?view=dotnet-plat-ext-8.0) object during a streaming
operation. For more information about streaming, see [ SqlClient Streaming
Support ](/en-us/dotnet/framework/data/adonet/sqlclient-streaming-support) .

[ ObjectDisposedException ](system.objectdisposedexception?view=dotnet-plat-
ext-8.0)

The [ Stream ](system.io.stream?view=dotnet-plat-ext-8.0) , [ XmlReader
](system.xml.xmlreader?view=dotnet-plat-ext-8.0) or [ TextReader
](system.io.textreader?view=dotnet-plat-ext-8.0) object was closed during a
streaming operation. For more information about streaming, see [ SqlClient
Streaming Support ](/en-us/dotnet/framework/data/adonet/sqlclient-streaming-
support) .

###  Examples

The following Windows application demonstrates the use of the [
BeginExecuteXmlReader
](system.data.sqlclient.sqlcommand.beginexecutexmlreader?view=dotnet-plat-
ext-8.0) method, executing a Transact-SQL statement that includes a delay of a
few seconds (emulat