Re: Oracle Cursors with .Net
Date: Fri, 6 Jun 2008 05:33:49 -0700 (PDT)
On Jun 5, 6:47 pm, emeshuris <emeshu..._at_gmail.com> wrote:
> 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 *&^,
I think I agree.
> stating that .Net
> apps and MS development is bad in some way.
Well that's a different issue. 8^)
> 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.
Thanks for the info. I'll be diving into some .NET development later
Ed Received on Fri Jun 06 2008 - 07:33:49 CDT