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

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

Why don't you try it and see?


This willl get you started. Then post your results.



public IDataReader CustomersGetAllReader()
{

String myConn ="Provider=Microsoft.JET.OLEDB.4.0;Data
Source=C:\\Wutemp\\Nwind.mdb;"; //naturally, you gotta have a database (mdb)
somewhere...change value here
String myQuery = "Select [CustomerID],[ContactName],[City] From
[Customers];";

OleDbConnection cn = new OleDbConnection(myConn);
cn.Open();
OleDbCommand cmd = new OleDbCommand(myQuery , cn);

return cmd.ExecuteReader(CommandBehavior.CloseConnection ); //


}



"Daniel" <softwareengineer98037 (AT) yahoo (DOT) com> wrote

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

No it is not disposed off. In the default case, it is flagged as closed and
sent back to the connection pool. If pooling is disabled, an unusual case,
and no more connections are open with an exact connection string match, the
resource becomes eligible for garbage collection at which point, the dispose
method on the resource will be called.

--
Regards,
Alvin Bruney
------------------------------------------------------
Shameless Author Plug
OWC Black Book 2nd Edition
Exclusively on www.lulu.com/owc
$24.99


"sloan" <sloan (AT) ipass (DOT) net> wrote

Why don't you try it and see?


This willl get you started. Then post your results.



public IDataReader CustomersGetAllReader()
{

String myConn ="Provider=Microsoft.JET.OLEDB.4.0;Data
Source=C:\\Wutemp\\Nwind.mdb;"; //naturally, you gotta have a database
(mdb) somewhere...change value here
String myQuery = "Select [CustomerID],[ContactName],[City] From
[Customers];";

OleDbConnection cn = new OleDbConnection(myConn);
cn.Open();
OleDbCommand cmd = new OleDbCommand(myQuery , cn);

return cmd.ExecuteReader(CommandBehavior.CloseConnection ); //


}



"Daniel" <softwareengineer98037 (AT) yahoo (DOT) com> wrote in message
news:OXdwsjj%23HHA.464 (AT) TK2MSFTNGP02 (DOT) phx.gbl...
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