How to call the SQL commands asynchronously in ADO.NET
version 2.0

Answer Posted / sandyni

In the asynchronous method ,the client creates a SqlCommand
object.the client application also sets the async attribute
in the connection string to true. Next, the client invokes
any of the asynchronous methods such as
beginExecuteNonQuery, BeginExecuteReader, or
BeginExecuteXmlReader through the SqlCommand object.

After executing the sql command the asynchronous methods
will close by using
EndExecuteNonquery,EndExecuteScalar,EndExecuteReader.

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the essential features of ado.net?

538


What are dataproviders?

545


What is difference between datatable and dataset?

521


What is the difference between sqldatareader and sqldataadapter?

487


What is shadow copy?

574






Explain the dataadapter class in ado.net?

661


How can we serialize the dataset object?

558


Which is faster entity framework or ado.net?

495


What is ado.net object model?

510


What is the meaning of executenonquery?

536


Which one of the objects is a high-level abstraction of the connection and command objects in ado.net?

629


What is the hierarchy of data in databases?

498


What is disconnected data?

578


describe the dataset object in ado.net.

520


Does sqlclient and oledb class share the same functionality?

533