DAAB-Connection closing

Topics: Data Access Application Block
Dec 10, 2008 at 8:09 PM

I went through some discussions and learnt that methods which we call on Database object will close connections for us.
ex: ExecuteNonQuerry will open and close connections for us. In case of DataReader, connection will be closed when user disposes DataReader.

With this assumption, my implementation does not dispose "Database" object. I executed a database request and opened to see if the session is closed on oracle server. I figured that the session is still open and  next time I tried executing the data base request it is reusing the same session( which seems good)

As dataaccess is behind service layer. each user will be creating ( instantiating mode is set to session and concurrency set to single) a connection. if  100 users are requesting a service, 100 sessions are opened for db and they are not closed.

I do not see any method to dispose "Database" object exposed in database application block.

I would appreciate if any one could point me in the right direction.

Dec 11, 2008 at 3:34 AM
Answered and discussed in http://www.codeplex.com/entlib/Thread/View.aspx?ThreadId=41994