Hello: > Hello, > > i found a little error in the dispose implementation. > 1 . why you close active reader when you dispose the fbcommand ? > > because with the microsoft application block you can do it : > > Database db = Helper.GetDB(); > using (DbCommand dbCommand = db.GetSqlStringCommand("SELECT * FROM > TOTO")) > { > return db.ExecuteReader(dbCommand); > } > > and after you can use the datareader. > Because the DataReader needs the command to be not disposed to be able to fetch data. When disposing the command it will be released in the Firebird Server as well, and the reader will be trying to use a non valid command.
-- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ No hay un solo rey que no descienda de un esclavo, ni un esclavo que no haya tenido reyes en su familia. _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider