IDataReader closed on return from proc

[Larry R]

Whenever I try the following, the reader that is returned is always
closed. What am I missing ?

When I look at the reader in the ExecuteReader, it is fine. THen it
gets closed on the returm.
Thanks!
=============== =============
public void Test()
{
IDBGateway gateway = new
DBGateway(Conne ctionChoice.DOM );
using (IDataReader reader =
gateway.Execute Reader( Utility.GroupSq l,null))
{
while (reader.Read())
{
Debug.WriteLine (reader[0].ToString());
}
}
}
=============== ====
Gateway code: ( and all of the factory stuff is fine )
public IDataReader ExecuteReader(s tring selectStatement ,
IDataParameterC ollection parameters)
{
try
{
using (IDbConnection connection =
factory.CreateC onnection())
{
IDbCommand command = connection.Crea teCommand();
command.Command Text = selectStatement ;
command.Command Type = CommandType.Tex t;
try
{
connection.Open ();
}
catch
{
throw;
}
IDataReader reader =
command.Execute Reader( CommandBehavior .CloseConnectio n);
return reader;
}
}
catch
{
throw;
}
}

[Jesse Houwing]

* Larry R wrote, On 22-6-2007 18:56:

Whenever I try the following, the reader that is returned is always
closed. What am I missing ?

When I look at the reader in the ExecuteReader, it is fine. THen it
gets closed on the returm.

The using clause around your connection will close the connection as
soon as that code block is left. It will close the reader with it.

There is a property you can set on the reader to close the connection
when the reader itself is being disposed. Which you are already setting.
So not disposing the connection immediately should solve your issue.

Jesse Houwing

Updated code:

public void Test()
{
IDBGateway gateway = new
DBGateway(Conne ctionChoice.DOM );
using (IDataReader reader =
gateway.Execute Reader( Utility.GroupSq l,null))
{
while (reader.Read())
{
Debug.WriteLine (reader[0].ToString());
}
}
}
=============== ====
Gateway code: ( and all of the factory stuff is fine )
public IDataReader ExecuteReader(s tring selectStatement ,
IDataParameterC ollection parameters)
{
IDbConnection connection;
try
{
connection = factory.CreateC onnection()
{
IDbCommand command = connection.Crea teCommand();
command.Command Text = selectStatement ;
command.Command Type = CommandType.Tex t;
try
{
connection.Open ();
}
catch
{
throw;
}

IDataReader reader =
command.Execute Reader( CommandBehavior .CloseConnectio n);
return reader;
}
}
catch
{
if (connection != null)
{
connection.Disp ose();
}
throw;
}
}

[Larry R]

Thanks so much!