SQLDataReader question

[CSharper]

I have a common program where I have a method which make a sql
connection and then prepares a SqlDataReader that is passed to the
calling method. But in the common method, I have the connection close
method as well. So when the query runs the data reader has data but
after the close is called the data reader becomes null. Is there a way
I can preserver the data reader after closing the connection??

Thanks.

 

[CSharper]

I have a common program where I have a method which make a sql
connection and then prepares a SqlDataReader that is passed to the
calling method. But in the common method, I have the connection close
method as well. So when the query runs the data reader has data but
after the close is called the data reader becomes null. Is there a way
I can preserver the data reader after closing the connection??

Thanks.

Found the answer, CommandBehaviour.

 

[sloan]

No.

You should consume the DataReader as fast as you can and then dispose of it.

If you need its contents....you put it(them) into some kind of custom
object.

Database connections aren't cheap.........

You can find a downloadable example here:
http://sholliday.spaces.live.com/Blog/cns!A68482B9628A842A!140.entry

of putting the results of an IDataReader into a custom object and/or
collection.

 

[sloan]

Yeah, you can use the enum.

Just know what you're doing. You actually don't want to keep it around (as
short as time as possible). <<( $.05 explanation)