You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Hey! I've got a usecase where a stored procedure returns multiple result sets that I need to parse. To do this, I need access to the SqlDataReader so I can call reader.NextResult() to move to the next result set. I see that the RowReader type lets us access the reader, but given the Sql.execute function reads the rows and advances the reader automatically, I'm not sure this will work the way I need it to. I'd need to somehow detect that the reader is on its last row and then advance it to the next result before the execute function's loop ends.
Would it be possible to add an executeReader function? Something like this:
Hey! I've got a usecase where a stored procedure returns multiple result sets that I need to parse. To do this, I need access to the SqlDataReader so I can call
reader.NextResult()
to move to the next result set. I see that theRowReader
type lets us access the reader, but given theSql.execute
function reads the rows and advances the reader automatically, I'm not sure this will work the way I need it to. I'd need to somehow detect that the reader is on its last row and then advance it to the next result before the execute function's loop ends.Would it be possible to add an
executeReader
function? Something like this:I'd be happy to create a pull request for it if you're interested in adding support for it.
The text was updated successfully, but these errors were encountered: