Multiple choice technology programming languages

You plan to develop a customer information application CustomABC that uses a Microsoft SQL Server database. CustomABC will be used frequently by a large number of users. Your application code must obtain the fastest possible performance when accessing the database and retrieving large amounts of data. You must accomplish this goal with the minimum amount of code. How should you design CustomABC?

  1. Use classes in the System.Data.OleDb namespace.

  2. Use classes in the System.Data.SqlClient namespace.

  3. Use remoting to connect to the SQL Server computer.

  4. Use interoperability to include legacy COM-based data access components.
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The System.Data.SqlClient namespace is specifically optimized for Microsoft SQL Server. It uses the TDS (Tabular Data Stream) protocol directly, providing better performance than the generic OleDb provider.

Keep practicing — related questions