Data Access Application Block - Closing connections? RRS feed

  • Question

  • User-839293131 posted
    Hi - I'm using ExecuteReader of the SQLHelper of Data Access Application Block (V2). It returns a datareader which I then pass to another function which takes that reader and binds its data to an object (or list of objects). But - I'm not sure if the connection is being closed by the SQLHelper as I'm getting connection pooling errors and I can't see where the connection would be closed. Thing is - as I pass my datareader to another function, I can't close the connection until I've finished using it and then, as I've only passed the datareader, I don't have access to close the connection. That is, unless, it's possible to get the active connection of a datareader and close it?
    Tuesday, January 20, 2009 12:41 PM

All replies