Re: Oracle Cursors with .Net

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 this year.
  Ed Received on Fri Jun 06 2008 - 07:33:49 CDT