I set the pooling to true in the web.config, and I've got some oracle connection which stay active (a lot).

I would know if the connection are correcly closed with the pooling to true and what can I do to close this connections ?

I use oracle 9i  and  EntitySpaces Version # 1.5.3.0

 

Thanks a lot. 

EntitySpaces does nothing special with Connection pooling, we merely open and close the connections as we should. Connection pooling is part of the .NET Framework and the Data Providers. EntitySpaces using OracleClient and not ODP.NET so you can bet it's done write

What you are seeing is normal, the .NET Framework will keep open connection in the connection pool so they are locked and loaded when needed.

See
http://www.ondotnet.com/pub/a/dotnet/2004/02/09/connpool.html

And do a search on Google for

http://www.google.com/search?hl=en&q=%22connection+Pooling%22+%22.net%22

Again, this is a .NET Framework "thing" and not an EntitySpaces thing, however, I do not think what you are seeing is a problem, it's a good thing.

 

---

EntitySpaces | Twitter | BLOG | Please honor our Software License

Thanks for the answer.

But when I want a connection to the sql server, instead of connect to an existing connection, a new connection is created even if a connection is open and inactif.

At the end, I've got to many connection inactive .

I would like to know if it's possible to not use the pooling and do you dispose the connection after the close ?

Thanks 

 

Well, I'm not sure why you are having this problem when no other developers in the entire .NET community have this issue? It's like taking the GAS out of .NET, never heard of such a thing. However, yes, you can disable connection pooling, but be prepared for your application to run 100 times slower? EntitySpaces handles connections properly whether or not pooling is enabled.

http://msdn2.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.connectionstring(VS.80).aspx

Scroll down on that link, you add "Pooling=false" on your connection string, at least for sql server.

---

EntitySpaces | Twitter | BLOG | Please honor our Software License