Q:
You are creating an ASP.NET application for XYZ. The company data is stored in a Microsoft SQL Server 6.5 database. Your application generates accounting summary reports based on transaction tables that contain million of rows.
You want your application to return each summary report as quickly as possible. You need to configure your application to connect to the database and retrieve the data in a away that achieves this goal.
What should you do?
Answer & Explanation
Answer: B) Use an OleDbConnection object to connect to the database, and use an OleDbCommand object to run a stored procedure that returns the data.
Explanation: We need to use an OleDBConnection to connect to SQL Server Version 6.5 (or earlier).
Incorrect Answers:
A: We could use a SqlConnection object only if the SQL Server were SQL Server 7.0, 2000 or later.
C: HTTP functionality is not required in this scenario. It would introduce unnecessary overhead.
D: ADODB is a legacy standard and should not be used here
View Answer
Report Error
Discuss