what is meant by connection pooling and event pumbling in
ado.net

Answers were Sorted based on User's Feedback



what is meant by connection pooling and event pumbling in ado.net..

Answer / gyany

Connection Pooling:-
Connection pooling reduces the number of times that new
connections need to be opened. The pooler maintains
ownership of the physical connection. It manages
connections by keeping alive a set of active connections
for each given connection configuration. Whenever a user
calls Open on a connection, the pooler looks to see if
there is an available connection in the pool. If a pooled
connection is available, it returns it to the caller
instead of opening a new connection. When the application
calls Close on the connection, the pooler returns it to the
pooled set of active connections instead of actually
closing it. Once the connection is returned to the pool, it
is ready to be reused on the next Open call.

Is This Answer Correct ?    10 Yes 2 No

what is meant by connection pooling and event pumbling in ado.net..

Answer / prabhat saxena(lmp)

connection pool is set of active connections object,so that
someone else can make use of it without waiting of creating
the new connection.The number of connections allowed to a
particular database may be limited due to server capacity
or database licensing restrictions.

Is This Answer Correct ?    4 Yes 4 No

what is meant by connection pooling and event pumbling in ado.net..

Answer / sandyni

when a connection opened first time the connection pooling
is created , and is based on the exact match connection
string given to the connection object.
It works only the connection string is same.otherwise it
will open a new connection. Hence connection pooling
maintains all these coneections to made the retreive of
data effectively and fastly.

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More ADO.NET Interview Questions

Can we bind one datareader wid two dropdown list?

5 Answers  


What are the Different layers in ADO.Net?

7 Answers  


can u tell me the why ADO does not support xml..

2 Answers   Crea,


What is ado.net architecture?

0 Answers  


Explain the ADO . Net Architecture ?

3 Answers  






How to enable and disable connection pooling?

0 Answers  


What is partial class?

0 Answers  


what purpose of Indexing creating? directly we can search the reqired row with the help of query?what is the use of indexing?

3 Answers  


Explain executenonquery?

0 Answers  


Why do we use sqldataadapter?

0 Answers  


What are two important objects of ADO.Net?

0 Answers  


Why DataReader is Forward Only?

16 Answers   IBM, NIIT,


Categories