Subsonic 2.2, all IDataReaders manually closed but still get Max Pool Connections with a single user?

Question

I have a very simple web application with 5 tables and one user. I keep getting timeout errors stating the max pool connection has been reached. Every opportunity to use an IDataReader the connection is manually closed. What am I doing wrong?

score 1 · Answer 1 · edited May 23 '17 at 12:13

1

Try calling LoadAndCloseReader() instead of just Load(). The Load() method opens a DataReader internally. See also: Is connection pooling working correctly in Subsonic?

edited May 23 '17 at 12:13

Community

1
1

answered Jun 16 '09 at 05:16

Dave Neeley

3,526
1
24
42

Subsonic 2.2, all IDataReaders manually closed but still get Max Pool Connections with a single user?

1 Answers1