Interested to Buy Any Domain ? << Click Here >> for more details...
what is meant by connection pooling and event pumbling in
ado.net
- 3 Answers
- 10012 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
What are the steps to connect to a database?
What are datareaders?
What are the major challenges in accessing data from a database?
What is the hierarchy of data in databases?
What are good ado.net object to replace to ado recordset object.
List all the steps in order, to access a database through ado.net?
What is untyped dataset?
Why is stored procedure used in ado.net?
What is different between sqlcommand object and command behavior object?
What is the functionality of data provider in ado.net?
What is ado.net code?
What are all the commands used with Data Adapter?
What is microsoft ole db provider for sql server?
Explain the DataAdapter.Update() and DataSetAcceptChanges() methods.
What do you know about ado.net's objects?
