Re: Oracle Cursors with .Net
Date: Thu, 5 Jun 2008 15:47:08 -0700 (PDT)
Message-ID: <cdb5d847-960d-4211-8348-100316264e85@v26g2000prm.googlegroups.com>
Thank you for your replies.
Personally I don't see opening a cursor as a bad thing.
As far as I know any read from the database requires a cursor, even if
it is implied.
My issue is with the DBA talking out of his *&^, stating that .Net
apps and MS development is bad in some way.
In any case, I wrote an app in .Net and did 153k reads in a row
without any issues.
In this test I used both api's the System.Data.Oracle (MS) and
Oracle.DataClient (OR).
In this loop, I used a command with datareader, a command with execute
scalar, and dataadapter.
If using a datareader, you must close the reader and the connection.
If using the executescalar, close the connection.
if using the dataadapter, you don't need to do anything.
Each command opened a cursor. Received on Thu Jun 05 2008 - 17:47:08 CDT