Interested to Buy Any Domain ? << Click Here >> for more details...
what is meant by connection pooling and event pumbling in
ado.net
- 3 Answers
- 9952 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
Describe datareader object of ado.net with example.
What is a string variable?
What does executenonquery () method return?
How to store data in memory?
Which one of the following objects is a high-level abstraction of the connection and command objects in ado.net?
Define bubbled event?
How do you merge 2 datasets into the third dataset in a simple manner?
how you will deal result set? How do you sort a dataset?If a dataset contains 100 rows, how to fetch rows between 5 and 15 only?
What is namespace in ado.net?
How can I retrieve two tables of data at a time by using data reader? Data reader read and forward only, how is it possible to get 2 tables of data at a time?
Explain why edit is not possible in repeater?
How to read data with the sqldatareader ?
Does ado.net use odbc?
What is dbcontext and dbset in entity framework?
Which is faster entity framework or ado.net?
