1. | Which data provider supports asynchronous processing through the client? |
|
2. | How do you enable asynchronous processing? |
|
3. | What command methods are used to process a DataReader asynchronously? |
|
Answers
1. | The SqlClient provider, which is part of ADO.NET and available through the System.Data.SqlClient namespace, is used to support asynchronous processing through the Command object. |
2. | You enable asynchronous processing by adding the Asynchronous Processing keyword to the connection string. |
3. | You will need to use both the BeginDataReader and EndDataReader methods to retrieve data asynchronously using the Command object. |