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

Reply via email to