Understanding Connection Pooling
What's Connection Pooling? Connection pooling is the ability of re-use your connection to the Database. This means if you enable Connection pooling in the connection object, actually you enable the re-use of the connection to more than one user. The connection pooling is enabled by default in the connection object. If you disable the connection pooling, this means the connection object which you create will not be re-used to any other user than who create that object. Shall I Enable/Disable Connection pool? Let's do an example to use what the time has required if we enable/disable the connection pool in an application. Sample 1(Connection Pooling is enabled): Create a console application and put the following lines of code to Main Method: SqlConnection testConnection = new SqlConnection ( @"Data Source=(local)\SQLEXPRESS;Initial Catalog=DEMO;Integrated Security=SSPI;" ); long startTicks = DateTime .Now.Ticks; for ( int i = ...