pooling ado.net connections

[EmmeS]

Here's a ado.net pooling question.... I have written a class that returns data using ado.net. Each time I read the database, the connection is re-opened and closed. Are these connections pooled together somehow so if I try to open it up again the connection is really "open"?

I'm concerned about the time it takes to re-open the connection every time I read the database. Is this "automatic"? Or do I need to do something special? It seems hard to do because I have many other classes use this class to read the database. Any suggestions or another approach to do this?

Thanks for you help,

Emme

 

[link9]

Yes, pooling does occur automatically, but there are also many things you can do to control how the connections pool, as well. Chances are, you don't need to mess with it, but if you are interested, here's a MS article on it:

http://msdn.microsoft.com/library/d...nectionpoolingforsqlservernetdataprovider.asp

paul