Re: cloning IDbDataReader (SqlDataReader)

> Perhaps the stored procedures need to be rethought but what
> could be done to allow access to the OUTPUT parameters but
> still have the SqlDataReader object to use?
>
> Peter

The Tabular Data Stream (TDS) protocol was defined in the early 1980's. It
has always worked this way and will probably continue to do so in the
future. The protocol specifies that output and return parameters get
attached to the end of data stream. As with any streaming protocol, the
reason for doing this is for efficiency. Having to maintain potentially
large amounts of query results, state, etc. on the server just so that you
can return output and return parameters "first" just isn't practical.

Kevin Hegg

===================================
This list is hosted by DevelopMentor®  http://www.develop.com

View archives and manage your subscription(s) at http://discuss.develop.com