[Firebird-net-provider] problem

[Pavol S. <pa...@st...>]

Hi,


i found there bug (may be)... when closing FbConnection.Close() and i 
did not close and dispose FbDataReader, exception was raised... null 
reference...

private void GetDBAnswer() {
            string dbCommandString = "select first 1 POLLID, TEXT, 
FINALVOTES from PollsAnswers where ID = @ID";
           
            FbConnection dbConn = new FbConnection(dbConnectionString);
            try {
                dbConn.Open();
               
                FbTransaction dbTran = dbConn.BeginTransaction();
                try {
                    FbCommand dbComm = new FbCommand(dbCommandString, 
dbConn, dbTran);
                    try {
                        dbComm.Parameters.Clear();
                        dbComm.Parameters.Add("@ID", id);
                       
                        FbDataReader dbData = dbComm.ExecuteReader();
                        try {
                            if (dbData.Read()) {
                                pollId = dbData.GetInt32(0);
                                text = dbData.GetString(1);
                                finalVotes = dbData.GetInt32(2);
                            }
                        }
                        finally {
//MARK                            dbData.Close();
//MARK                            dbData.Dispose();
                        }
                    }
                    finally {
                        dbComm.Dispose();
                    }
                }
                finally {
                    dbTran.Commit();
                    dbTran.Dispose();
                }
            }
            finally {
                dbConn.Close();
            }
        }

ir two marked lines was not there exception was raised, and when i added 
that lines everything is ok...

thanx
p.