Re: Oracle Cursors with .Net

From: emeshuris <emeshuris_at_gmail.com>
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

Original text of this message