Skip to main content

This browser is no longer supported.

Upgrade to Microsoft Edge to take advantage of the latest features, security
updates, and technical support.

[ Download Microsoft Edge ](https://go.microsoft.com/fwlink/p/?LinkID=2092881
) [ More info about Internet Explorer and Microsoft Edge
](https://learn.microsoft.com/en-us/lifecycle/faq/internet-explorer-microsoft-
edge)

Table of contents  Exit focus mode

Language

  *   *   *   * 

Read in English  Save  [ ](https://github.com/dotnet/dotnet-api-
docs/blob/main/xml/System.Data.SqlClient/SqlCommand.xml "Edit This Document")

Table of contents  Read in English  Save  [ Edit
](https://github.com/dotnet/dotnet-api-
docs/blob/main/xml/System.Data.SqlClient/SqlCommand.xml "Edit This Document")
Print

Twitter  LinkedIn  Facebook  Email

Table of contents

#  Sql  Command.  Begin  Execute  Reader Method

  * Reference 

Feedback

##

##  Definition

Namespace:

     [ System.Data.SqlClient ](system.data.sqlclient?view=dotnet-plat-ext-8.0)

Assembly:

     System.Data.SqlClient.dll 

Assembly:

     System.Data.dll 

Package:

     System.Data.SqlClient v4.8.6 

Important

Some information relates to prerelease product that may be substantially
modified before itâs released. Microsoft makes no warranties, express or
implied, with respect to the information provided here.

Initiates the asynchronous execution of the Transact-SQL statement or stored
procedure that is described by this [ SqlCommand
](system.data.sqlclient.sqlcommand?view=dotnet-plat-ext-8.0) , and retrieves
one or more result sets from the server.

##  Overloads

[ BeginExecuteReader() ](system.data.sqlclient.sqlcommand.beginexecutereader?view=dotnet-plat-ext-8.0#system-data-sqlclient-sqlcommand-beginexecutereader) |  Initiates the asynchronous execution of the Transact-SQL statement or stored procedure that is described by this [ SqlCommand ](system.data.sqlclient.sqlcommand?view=dotnet-plat-ext-8.0) , and retrieves one or more result sets from the server.   
---|---  
[ BeginExecuteReader(CommandBehavior) ](system.data.sqlclient.sqlcommand.beginexecutereader?view=dotnet-plat-ext-8.0#system-data-sqlclient-sqlcommand-beginexecutereader\(system-data-commandbehavior\)) |  Initiates the asynchronous execution of the Transact-SQL statement or stored procedure that is described by this [ SqlCommand ](system.data.sqlclient.sqlcommand?view=dotnet-plat-ext-8.0) using one of the [ CommandBehavior ](system.data.commandbehavior?view=dotnet-plat-ext-8.0) values.   
[ BeginExecuteReader(AsyncCallback, Object) ](system.data.sqlclient.sqlcommand.beginexecutereader?view=dotnet-plat-ext-8.0#system-data-sqlclient-sqlcommand-beginexecutereader\(system-asynccallback-system-object\)) |  Initiates the asynchronous execution of the Transact-SQL statement or stored procedure that is described by this [ SqlCommand ](system.data.sqlclient.sqlcommand?view=dotnet-plat-ext-8.0) and retrieves one or more result sets from the server, given a callback procedure and state information.   
[ BeginExecuteReader(AsyncCallback, Object, CommandBehavior) ](system.data.sqlclient.sqlcommand.beginexecutereader?view=dotnet-plat-ext-8.0#system-data-sqlclient-sqlcommand-beginexecutereader\(system-asynccallback-system-object-system-data-commandbehavior\)) |  Initiates the asynchronous execution of the Transact-SQL statement or stored procedure that is described by this [ SqlCommand ](system.data.sqlclient.sqlcommand?view=dotnet-plat-ext-8.0) , using one of the ` CommandBehavior ` values, and retrieving one or more result sets from the server, given a callback procedure and state information.   
  
##  BeginExecuteReader()

Initiates the asynchronous execution of the Transact-SQL statement or stored
procedure that is described by this [ SqlCommand
](system.data.sqlclient.sqlcommand?view=dotnet-plat-ext-8.0) , and retrieves
one or more result sets from the server.

    
    
    public:
     IAsyncResult ^ BeginExecuteReader();
    
    
    public I