🎴 Flashcard Mode
Database Programming and .NET Framework
Card1 / 20
Mastered0
Review0
QuestionClick to flip
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?
AnswerClick to flip back
A
to use the same application logon ID and password for every connection to the TestKing1 database.
💡 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.