You are designing an ASP.NET Web application that connects to a Microsoft SQL Server database. This application will have thousands of concurrent users. You must choose a connection strategy that optimizes database resources.

What should you do?

High-performance applications keep connections to the data source in use for a minimal amount of time and take advantage of performance-enhancing technology, such as connection pooling.

Connecting for the duration of the session monopolizes database connections, a finite resource.