> What about this one: > > return new DbEnumerator(this, = > > this.IsCommandBehavior(CommandBehavior.CloseConnection));
In fact when the second parameter of the dbenumerator constructor is true the datareader is automatically close at the end of the iteration; "MSDN said" : [DbEnumerator (IDataReader, Boolean) Initializes a new instance of the DbEnumerator class using the specified DataReader, and indicates whether to automatically close the DataReader after iterating through its data.] So when the commandbehavior is set to closeconnection the second parameter is set to true else is set to false ! _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider