Connection pooling

Question

How can connection pooling be enabled?

Mukesh Kumar · Answer

connection string with the connection pooling option: string sqlConnectString = "Data Source=localhost;Integrated security=SSPI;Initial Catalog=AdventureWorks;" ; SqlConnection connection = new SqlConnection (); // Set the connection string with pooling option connection.ConnectionString = sqlConnectString + "Connection Timeout=30;Connection Lifetime=0;Min Pool Size=0;Max Pool Size=100;Pooling=true;" ; A Connection String in the Web.Config file with connection pooling option: connectionStrings > clear /> add name = " sqlConnectionString " connectionString = " Data Source=mySQLServer;Initial Catalog=myDatabase;Integrated Security=True;Connection Timeout=15;Connection Lifetime=0;Min Pool Size=0;Max Pool Size=100;Pooling=true; " /> connectionStrings >

Jignesh Trivedi · Answer

Hi, In connection string, you must enable pooling and assign maximum pooling size. please refer. http://www.codeproject.com/KB/dotnet/ADONET_ConnectionPooling.aspx http://msdn.microsoft.com/en-us/library/8xx3tyca%28v=vs.71%29.aspx hope this help.

Krishna Garad · Answer

In connection string you can set it true as well as MinPool Size and MaxPoll size like Data Source=..;User Id=..;Password=..;Polling=true;MinPool Size=10;MaxPoll Size=100;