Multiples Table in DataReader
I normally use DataSet
because It is very flexible. Recently I am assigned code optimization task , To reduce hits to the database I am changing two queries in a procedure. one Query returns the count
and the other returns the actual data
. That is , My stored procedure
returns two tables. Now, I know how to read both tables using DataSets
, But I need to read both tables using DataReader
. In search of that I found This.