what is meant by connection pooling and event pumbling in
ado.net
- 3 Answers
- 8867 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Which method in OLEDBAdapter is used to populate dataset with records?
Explain how to create dynamic gridview?
What is ado net stands for?
What is the difference between linq and ado.net?
What is an ado?
What is connection string?
What are the rules to implement connection pooling?
What are all the different methods under sqlcommand?
Explain the role of data provider in ado.net?
Why do we use sqldataadapter?
What are the different methods by which we can populate a dataset?
What is dataset object? Explain the various objects in dataset.
How to add a check box or a dropdown list to a column in a datagrid?
What is command class in ado.net?
What is ado recordset?
