Can you explain how to enable and disable connection pooling?
Set Pooling=true. However, it is enabled by default in .NET.
To disable connection pooling set Pooling=false in connection string if it is an ADO.NET Connection.
If it is an OLEDBConnection object set OLEDB Services=-4 in the connection string.
Can you explain how to enable and disable connection pooling?
To enable connection pooling :SqlConnection myConnection = new SqlConnection(@"Data Source=(local)\SQLEXPRESS;Initial Catalog=TEST;Integrated Security=SSPI;");
This has connection pooling on by default.
To disable connection pooling:SqlConnection myConnection = new SqlConnection(@"Data Source=(local)\SQLEXPRESS;Initial Catalog=TEST;Integrated Security=SSPI;Pooling=false;");
