| 
 Posted by Jobs on 06/13/37 11:39 
What is Maximum Pool Size in ADO.NET Connection String? 
Maximum pool size decides the maximum number of connection objects to 
be pooled. If the maximum pool size is reached and there is no usable 
connection available the request is queued until connections are 
released back in to pool. So it's always a good habit to either call 
the close or dispose method of the connection as soon as you have 
finished work with the connection object. 
 
How to enable and disable connection pooling? 
For .NET it's enabled by default but if you want to just make sure 
set Pooling=true in the connection string. To disable connection 
pooling set Pooling=false in connection string if it's a ADO.NET 
Connection. If it's an OLEDBConnection object set OLE DB Services=-4 
in the connection string. 
 
Full Interview Questions for .NET and SQL Server 
http://www.geocities.com/dotnetinterviews/ 
Help the community to make job search easier mail your questions to 
jobatyourdoorstep@yahoo.co.in 
Looking for a onsite job mail your resumes at 
jobatyourdoorstep@yahoo.co.in
 
[Back to original message] 
 |