wyrd
Well-known member
Can .NET (C# specifically) handle a pointer to a cursor thats returned from either a UDF or Procedure (OUTPUT) from within SQL Server? If so where can I find some information on this?
Handling cursor pointers...
- Thread starter wyrd
- Start date
Derek Stone
Exalted One
ADO.NET doesnt support cursors to any great extent, although the Oracle provider does include reference cursors, which will most likely be of little use to you.
wyrd
Well-known member
Well thats just sucky. I was at least hoping for an option to deal with cursors via pointers. Are there any sorts of hacks that I could look into for dealing with returned cursor pointers?
Derek Stone
Exalted One
Not that I am aware of, no. However if you provide us with some details Im sure an alternative solution could be established.
wyrd
Well-known member
I wasnt talking about any problem I was having in particular, it was just more of a curious thing for future reference. Just about everything I can think of that would require a cursor can be done within a stored procedure or UDF, so I suppose in the end it doesnt really matter. But still, it would of been good info to know "just in case."