Close the reader before closing the connection.

Question

If you always close the DataReader before closing the connection, or is it ok to close the connection? Just closing the connection, does it effectively close the reader?

(This is for C # .net 3.5)

Thanks!

Answer 1

In addition to clearly defining your intent, this can be found in the Microsoft documentation ( Extracting data using DataReader (ADO.NET) ):

You should always call the Close method when you are done using the DataReader object.

Answer 2

Close also DataReader.

imo. if it implements IDisposable or has a .close () method or a similar construct mentioned in the documentation that you should call when you are done with this instance, do it. Do not rely on anything else to take care of it for you - unless the documentation clearly states that it is. For DataReader / DbConnection - the docs don't mention anything like that.

Answer 3

I prefer using C # with statment, which is called for dispose () for you. Here is a worthy explanation.

Using Status