MCITP Self-Paced Training Kit Exam 70-442 .Designing and Optimizing Data Access by Using Microsoft SQL Server 2005

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?

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.