Women in Technology

Hear us Roar



Article:
  ADO.NET Connection Pooling Explained
Subject:   After running SqlHelper.ExecuteReader connection pooling stops
Date:   2006-01-25 23:36:42
From:   ManojAgarwal
Hi,


I ran this sample and noticed that if ,as mentioned, the pooled connections are closed then this code recovers from it. But what I noticed is that after recovering the no. of connections in the pool is just one (I am checking open connections by the method mentioned)- so somehow pooling is not taking place. I didn't modify the code.


Also, another thing I noticed is that for SQL Server (I have 2005 version) the pool size is not 100 but 2 by default.