Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

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


Please Help Members By Posting Answers For Below Questions

How can we check that some changes have been made to dataset since it was loaded?

974


What is sql command in ado net?

967


Explain how to pass multiple tables in datasets simultaneously?

1045


What is the meaning of object pooling?

1238


What is a data control clerk?

1047


What is ado.net code?

938


What is the hierarchy of data in databases?

950


What is a datareader object?

1107


How to check if a datareader is closed or opened? IsClosed()

1033


What are the drawbacks of using ado.net?

983


Describe briefly an ADO.NET Dataset ?

1092


What is the use of connection object in ado.net?

1061


Explain the difference between data reader and data set?

933


Why is it important to close an ado.net application?

1028


What is ado rdo dao in visual basic?

1172