?
Solved

connection pooling in .net

Posted on 2006-06-01
1
Medium Priority
?
239 Views
Last Modified: 2010-04-16
I was looking into using connection pooling for SqlConnections, and came across the following:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconconnectionpoolingforsqlservernetdataprovider.asp

am I reading this correctly in that the .net framework will *automatically* create a connection pool for you?  This seems like a silly question, but I really was not expecting this to be the default behaviour.
0
Comment
Question by:ARACK04
1 Comment
 
LVL 9

Accepted Solution

by:
Joeisanerd earned 1000 total points
ID: 16813293
yep it's true, if the connection strings are the same then once the pool is started other sqlconnections can use it.  Of course you might more control over  it so you put a pool size in you connect string.  

If you use system monitor and put a counter on sql connections you can see it in action, but it will open a couple coonections before reusing others.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Article by: Najam
Having new technologies does not mean they will completely replace old components.  Recently I had to create WCF that will be called by VB6 component.  Here I will describe what steps one should follow while doing so, please feel free to post any qu…
Introduction Although it is an old technology, serial ports are still being used by many hardware manufacturers. If you develop applications in C#, Microsoft .NET framework has SerialPort class to communicate with the serial ports.  I needed to…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
Suggested Courses

807 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question