is a reader automaticaly disposed if the connection it is associated with is closed?

Daniel

is a reader automaticaly disposed if the connection it is associated with is
closed?

what will happen if an app:

while true
open connection
open reader
close connection
end while

Sep 18 '07 #1

Subscribe Post Reply

1150

Samuel R. Neff

There isn't much point in asking the question. Always close/dispose
your disposable objects. Always. :-)

If for purely educational reasons you want to know the answer of what
happens when you don't dispose a reader and instead dispose the
connection, you have to get more specific. The behavior could vary
depending on which reader--mssql, oledb, oracle, sybase, sqlite,
mysql, and on and on. I know for sure that the SQLite implementation
has a lot of code in it to handle this situation and will close
readers, but it's 'cause the author is extremely forgiving to bad
developers that don't close their disposable objects.

Sam

------------------------------------------------------------
We're hiring! B-Line Medical is seeking .NET
Developers for exciting positions in medical product
development in MD/DC. Work with a variety of technologies
in a relaxed team environment. See ads on Dice.com.

On Tue, 18 Sep 2007 14:14:46 -0700, "Daniel"
<so*******************@yahoo.comwrote:

>is a reader automaticaly disposed if the connection it is associated with is
closed?

what will happen if an app:

while true
open connection
open reader
close connection
end while

Sep 18 '07 #2

Similar topics

BinaryWriter/Reader question

by: Filip Strugar | last post by:

Considering that the BinaryWriter/BinaryReader object closes the underlaying stream upon being gc collected, is the following code correct, and if it is what is the reason preventing BinaryWriter...

C# / C Sharp

sql reader error

by: juli jul | last post by:

Hello, I am using a reader in order to read query results: SqlDataReader rdr = null; SqlDataReader rdr_rows=null; this.conn.Open(); SqlCommand cmd = new SqlCommand("select name from...

C# / C Sharp

data reader question

by: Mike P | last post by:

I'm using 1 connection to open 3 separate data readers to read data into 3 data grids. However, when I try to use the 2nd reader it says that the first reader must be closed. So I use Close() to...

ASP.NET

Invalid attempt to FieldCount when reader is closed error

by: Patrick Olurotimi Ige | last post by:

Why do i get "Invalid attempt to FieldCount when reader is closed" Is the problem the way the datareader reads data as opposed to a dataset? When trying to compile this code:- Dim reader As...

ASP.NET

Invalid attempt to Read when reader is closed.

by: sivam.solai | last post by:

Public Function GetTopLevelThreadName(ByVal ThreadID As Integer) As SqlDataReader Sp_Datasql = "WS_Get_TopLevelThreadName" SqlParam = New SqlParameter(0) {} Try SqlParam(0) = New...

ASP.NET

SQL Reader Again

by: Saurabh | last post by:

Hi, I am getting the below mentioned error when I try to update a table Exception: Unable to update Person records Exception : System.Data.SqlClient.SqlException: Timeout expired. The...

C# / C Sharp

There is already an open DataReader associated with this Connection which must be closed first

by: fniles | last post by:

I am using VB.NET 2003, SQL 2000, and SqlDataReader. As I read data from tblA, I want to populate tblB. I use SQLDataReader for both tables. I do not use thread. When I ExecuteReader on tblB, I...

Visual Basic .NET

SQL Server connection pooling

by: fniles | last post by:

I am using VB.NET 2003 and SQL 2005. To use connection pooling and avoid the error "There is already an open DataReader associated with this Connection which must be closed first." , I understand...