sql server connection pooling

  • Thread starter Thread starter Green
  • Start date Start date
G

Green

Hi,
I has a web application which execute lots of query and store procedure
from the sql server 2000. I want to have a central controlled connection
pool so as to all the connection will get the connection from this pool and
return to this pool. How can i do this. Is there any article recommended?

Appreciate in advance!
 
Green said:
I has a web application which execute lots of query and store procedure
from the sql server 2000. I want to have a central controlled connection
pool so as to all the connection will get the connection from this pool and
return to this pool. How can i do this. Is there any article recommended?
Click to expand...

You don't need to do anything special in your own code - just create
new instances of SqlConnection and call Dispose as soon as you've
finished with them (the using statement is handy here) - the data
provider will do appropriate pooling.
 
Back
Top