Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Support breaking each buffer into separate calls to Execute() #4

Open
developmentalmadness opened this issue Mar 24, 2012 · 0 comments
Assignees

Comments

@developmentalmadness
Copy link
Owner

Sql Server doesn't start the stored procedure until the stream has completed (IEnumerator.MoveNext() == false). In cases where the full dataset may be too much for Sql Server to process at once. The client would prefer to call ExecuteXXX() each time the buffer flushes instead of buffering to the same stream. This should all work internally w/o any changes to the interface other than adding a new value to the SqlStreamBehavior enum.

NOTES:

  • This option should be ignored by ExecuteReader and ExecuteScalar, or we can offer a callback for these so the client can handle what they want to do with each response.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant