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
What do you mean by ‘batch updates’?
What are the drawbacks of using ado.net?
Explain the role of data provider in ado.net? What is the role of data provider in ado.net?
What is connected architecture in ado.net?
Which name space is used to get assembly details?
What are ado.net objects?
Can we connect two dataadapters to same data source using single connection at same time?
Explain how to find the given query is optimised one or not?
What are the important features of ado.net 2.0?
What are the advantages and drawbacks of using ado.net?
Define executenonquery?
What are the major difference between classic ADO and ADO.NET?
How do you find the count of records in a dataset?
What are the different methods available under the sqlcommand class to access the data?
Why is it important to close an ado.net application?