ADO.NET connection Pool question

[coollzh]

i have read a article :
"Als o remember that each .NET assembly gets a unique PID. This means that
each new assembly you run gets its own pool¡ªregardless of the similarity of
function or the fact that their ConnectionString values are identical."

URL:
http://www.winnetmag.com/SQLServer/Articles/ArticleID/38356/pg/3/3.html

as above , my web application with many Assemblies will maintain many
differents connection pool? Is it true?

 

[M. Zeeshan Mustafa]

ADO.NET manages connection pooling for assemblies itself.

learn more about ADO.NET sql client connection pooling at:
http://msdn.microsoft.com/library/e...nectionPoolingForSQLServerNETDataProvider.asp

 

[Pablo Castro [MS]]

That's not correct. In ADO.NET connection pools are per-appdomain, not
per-assembly or per-PID.

--
Pablo Castro
Program Manager - ADO.NET Team
Microsoft Corp.

This posting is provided "AS IS" with no warranties, and confers no rights.