Link to home
Start Free TrialLog in
Avatar of RealMrTea
RealMrTea

asked on

Connection Pooling

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
ASKER CERTIFIED SOLUTION
Avatar of _kiwi_
_kiwi_
Flag of France image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of RealMrTea
RealMrTea

ASKER

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