FbCommand closes the ActiveReader when is disposed. This  behavior is diferent 
from other DbCommand implemetations
------------------------------------------------------------------------------------------------------------------

                 Key: DNET-89
                 URL: http://tracker.firebirdsql.org/browse/DNET-89
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 2.1.0 Beta 3
         Environment: Windows XP
            Reporter: Fabiano Rezende
            Assignee: Carlos Guzman Alvarez


>From FbCommand.cs:

protected override void Dispose(bool disposing)
{
        lock (this)
        {
                if (!this.disposed)
                {
                        try
                        {
                                // If there     are     an active reader close 
it
                                this.CloseReader();      <<<======  
                                
                                .
                                .
                                .

                                this.disposed = true;
                        }
                        finally
                        {
                                base.Dispose(disposing);
                        }
                }
        }
}


IMHO all ADO.NET provider must have the same behavior.

For example:

The Microsoft.Practices.EnterpriseLibrary.Data.Database has the following 
method that returns a DataReader

public IDataReader ExecuteReader(string storedProcedureName, params object[] 
parameterValues)
{
            using (DbCommand command = 
GetStoredProcCommand(storedProcedureName, parameterValues))
            {
        return ExecuteReader(command);
            } // << command is disposed here and the returned DataReader will 
be closed
}


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Reply via email to