Connection pool that connection should use - ADO.NET
Q. What determines the connection pool that a connection should use?
1. A connection string
2. The identity or credentials of the user opening the connection
3. The database being connected to
4. The connection object used to connect to the database
- Published on 19 Oct 15a. 1, 2
b. 1, 2, 3
c. 1, 3
d. 1, 4
ANSWER: 1, 2
Connecting with the database is time consuming and resource intensive task. Connection pool is cache that stores connection string. These connection strings can be reused for future requirements.Only connections with the same configuration can be stored in a pool. Connections are divided into pools by connection string and by identity when integrated security is used.
Connection pooling removes the overhead of making a new connection.
