Help Requried on Connection Pooling [Urgent]

[Guest]

Hi ,

i have a requriment where i need to perform connection pooling through
c#.net code .My database is Sybase.
Can any one forward me link or suggest me on how to start to write code for
this.

Regards
Mani.

 

[Patrice]

AFAIK connection pooling is taken care by ADO.NET. Try :
http://msdn2.microsoft.com/en-us/library/8xx3tyca.aspx

(and adding "urgent" is considered a bad practice as you have no way to know
how urgent it is compared with others except it's yours).

 

[Guest]

Thanks a lot for your reply , But my requriment is that i have a
DatabaseFactory Class which does all insert,update,delete of records. The
database factory class needs connection object.
I need to design a class which will handle bunch of connection objects and
will respond based on the request.

For example if DatabaseFactory class needs a connection object then it will
request the connectionpooling class for the connection object.The connection
pooling class will check its connection objects and return the connection
object which is not in use.

As i am working on a Enterprise application i need to desing a class which
manages the database connection in a better way.

 

[Patrice]

Hummm. Im' no sure to really understand. As said preivously this is AFAIK
*already* done by ADO.NET ie. when a connection is closed it is actually
returned to a pool and when you ask for another connection it return an
available connection from the pool.

I would double check first that connection pooling doesn't work for some
reason with the provider you are using (it looks like from a quick search
that "DataDirect" Sysbases components do have connection pooling).

It seems you have some details on a pool manager at
http://www.datadirect.com/developer/net/dot-net-connection-pooling/index.ssp
(try "connection pooling" implementation in google) but really check before
this is not already done for you...

 

[William \(Bill\) Vaughn]

Ah, no. ADO.NET does not implement connection pooling--it's handled by each
..NET data provider. Looking at the documentation for SqlClient might not
help much if you're working with DB2 or Sybase. There is a native Sybase
provider that has its own interpretation of the connection pooling features.
No, I don't know how to configure it unless it matches the SqlClient
provider.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

 

[Patrice]

Yes since then I posted a link on what appears to be a Sybase provider that
supports connection pooling...

Mani, the first step would be likely to find out wether the Sybase provider
you are using supports connection pooling or not (hopefully most will ?)