|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Help Requried on Connection Pooling [Urgent]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. 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). "Mani" <M***@discussions.microsoft.com> a écrit dans le message de news: AF3521DA-70EF-4ED5-99D6-C743618DD***@microsoft.com...Show quote > 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. 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. Show quote "Patrice" wrote: > 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). > > > "Mani" <M***@discussions.microsoft.com> a écrit dans le message de news: > AF3521DA-70EF-4ED5-99D6-C743618DD***@microsoft.com... > > 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. > > > 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... ---- Patrice "Mani" <M***@discussions.microsoft.com> a écrit dans le message de news: 55536DB6-1559-4644-A618-71A7EC91A***@microsoft.com...Show quote > 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" wrote: > >> 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). >> >> >> "Mani" <M***@discussions.microsoft.com> a écrit dans le message de news: >> AF3521DA-70EF-4ED5-99D6-C743618DD***@microsoft.com... >> > 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. >> >> >> 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. -- Show quote____________________________________ 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" <http://www.chez.com/scribe/> wrote in message news:OaMkE19WHHA.4764@TK2MSFTNGP05.phx.gbl... > 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). > > > "Mani" <M***@discussions.microsoft.com> a écrit dans le message de news: > AF3521DA-70EF-4ED5-99D6-C743618DD***@microsoft.com... >> 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. > > 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 ?) "William (Bill) Vaughn" <billvaRemoveT***@nwlink.com> a écrit dans le message de news: eoM1oFDXHHA.4***@TK2MSFTNGP05.phx.gbl...Show quote > 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" <http://www.chez.com/scribe/> wrote in message > news:OaMkE19WHHA.4764@TK2MSFTNGP05.phx.gbl... >> 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). >> >> >> "Mani" <M***@discussions.microsoft.com> a écrit dans le message de news: >> AF3521DA-70EF-4ED5-99D6-C743618DD***@microsoft.com... >>> 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. >> >> > >  |
|||||||||||||||||||||||
Other interesting topics