Connection Pooling

[RamHardikar]

Could someone point me to an example which shows implemention of connection pooling

 

[ca8msm]

http://www.google.co.uk/search?hl=en&q=+"ASP.NET"+Connection+Pooling&meta=

--------------------------------------------------------------------------------------------------------------------------------------------

Need help finding an answer?

Try the search facility (

http://www.tek-tips.com/search.cfm)

or read FAQ222-2244 on how to get better results.

 

[RamHardikar]

When I say - OleDbConnection cn = new OleDbConnection();

Does provider create a connection pool internally?

 

[chiph]

Does provider create a connection pool internally?

Maybe. It depends on the underlying provider. The OleDb series of methods are just a passthrough to a database vendor-provided library. There are other considerations, such as whether you're running in COM+/EnterpriseServices, if the connection string is identical, and whether you're using integrated security.

You can include the min pool size and max pool size parameters in your connection string, and that might give ADO.NET a hint that you want to use pooling.

Probably the best thing to do is open and close several connections, and monitor from the database side using your DB admin tools to see if they immediately close, or close after a few minutes.

Chip H.


____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first

 

[Ecreations]

RamHardikar,
According to Appdev's Mary Chipman "One of the author for Ado.net Traning
Ado.NET Training If you use the Same Connection the Provider will keep the connection as is and will not create a new connection

as chip mentioned above, you can test it yourself and monitor the connection pool


Good luck

http://ecreationscanada.com

What would you attempt to accomplish if you knew you would not fail?