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 15

a. 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.
 

    Discussion

  • PAVAN keshari   -Posted on 23 Feb 20
    I am looking web development job

Post your comment / Share knowledge


Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)