Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Output parameters not readable when used with a DataReader

When using a DataReader object to access data from a database (such as SQL Server) through stored procedures, any output parameter added to the Command object before executing are not being filled after reading. I can read row data just fine, as well as all input parameters, but not output ones.

like image 223
Sean Hanley Avatar asked Sep 15 '08 18:09

Sean Hanley


1 Answers

This is due to the "by design" nature of DataReaders. Any parameters marked as ParameterDirection.Output won't be "filled" until the DataReader has been closed. While still open, all Output parameters will more than likely just come back null.

The full Microsoft KB article concerning this can be viewed here.

like image 191
Sean Hanley Avatar answered Oct 13 '22 12:10

Sean Hanley