Multiple choice technology programming languages

You develop a Windows-Based application that accesses a Microsoft SQL Server database named ABC. Users must supply a user name and password when they start the application. This information is then used to dynamically build a connection string. When you test the application, you discover that it is not using the SqlClient connection pooling feature. You must reduce the time needed to retrieve information. How should you modify the connection string?

  1. to use the Windows user logon when connection to the TestKing1 database.

  2. to use the SQL Server used login when connection to the TestKing1 database.

  3. to use the same application logon ID and password for every connection to the TestKing1 database.

  4. to use the guest login ID and password for every connection to the TestKing1 database.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Connection pooling in ADO.NET relies on exact string matching. If every user has a unique connection string (different credentials), a new pool is created for each, defeating the purpose. Using a single service account enables pool reuse.

Keep practicing — related questions