[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Connection Pooling

Posted on 2004-11-10
3
Medium Priority
?
384 Views
Last Modified: 2008-03-06
This may be a question more suited for an ADO.NET category but someone out there has got to know.

We have an application which currently uses MTS and COM+ to facilitate connection pooling amoung our client applications.  We want to move away from COM and more towards .NET development and we are looking at re-writing the back end (Data Access End) as a .NET Web Service (or a collection of webservices).

If we use one web service and place all our web methods in the service we should be taking advantage of ADO.NET connection pooling.  Right?  How about if we have multiple services?  Whatt about multiple services wrapped inside the same project so that they are in the same assembly?

I guess it would realy depend on where the pooling was taking place, at the SQL server level, or at the application level.  For example, if I have ApplicationA that access a database with the same user name and password as ApplicationB, are the connections pooled even though they are comming from different applications?

Thanks for any insight into connection pooling and web services,
Eric
0
Comment
Question by:RealMrTea
2 Comments
 
LVL 3

Accepted Solution

by:
_kiwi_ earned 2000 total points
ID: 12565140
Hi Eric,

Connection pooling in ADO.Net is made to allow you to, even if you want, develop, say one method by web service, and still use the power of connection pooling.

Pooling is available at the application Level, not just at the class or requesdt level.

If you have two web services in a single application, they will automatically share the same pool if they use the same connection string.

Just think about closing your SqlConnection objects just after using them.

Check : http://www.15seconds.com/issue/040830.htm for more info.

Cheers,
Julien
0
 
LVL 7

Author Comment

by:RealMrTea
ID: 12840587
Whoops...Sorry for the delay.  This project kind of got put on the back burrner and I wanted to see if any one else had any ideas.

My thanks and appologies kiwi,
Eric
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

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

This article introduced a TextBox that supports transparent background.   Introduction TextBox is the most widely used control component in GUI design. Most GUI controls do not support transparent background and more or less do not have the…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
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. …
Suggested Courses

834 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