500pts: Confirmation for connection pooling in c#?
Posted on 2006-11-03
I wonder if anyone can help. I have an application that i wish to keep at least 10 connections open to the database and as i need to increase or decreases the pool when i need to..
Now i believe I can do this in c# with the oracle Data Provider for .NET...
My question is .... basically i am going to be using it for a web service... I presume when I have those 10 connections -- they are automatically OPEN and in my Code i still use a new connection object which i do like this (which closes the object)
_conn is a string that can be accessed from Global - the connection string.
using (OracleCommand cmd = new OracleCommand("supp.PACK_TEMP.GET_INFO",Global._conn))
My worry is that when i am opening and closing connections all the time, this isn't opening and closing a connection to the database but is setting the connection in the pool to "in use" and "not in use"....
This is where i am a little worried... I want to ensure that once the connection is OPEN it stays open.... for others methods to access...
So when i am doing Open and Close in my code... i am not actually opening connections to the db but using existing OPEN connections..
I hope someone can help
Thanks in advance