Im using Visual Studio 2003 .NET and ADO.NET to connect to an Oracle 10g database. Im making use of the Oracle .NET provider. I will be making several calls to the same Oracle dbase so figured I should leave "open" the connection to make all subsequent query requests. One thing I';ve been strugling with in .NET is .ExecuteRead() requests failing due to "connection is already open". Normally i have to close the current connection, create a brand new Connection and Command object then make the new SQL query. This just seems so inefficent and slow. Is it possible to leave open the connection to make subsequent query calls with little overhead and speed reduction or is it a requirement to create a new connection and object in .NET?
Can u please provide me with a sample C# conenction to the Oracle .NET Provider to achieve this.