Re: Connection Level

[dotNET User Group Hyd]

New Message on dotNET User Group Hyd Connection Level Reply   Recommend Message 2 in Discussion From: Sudhakar_MVP Hi   In the method one, i think you gonna use a static singleton connection object which will be used across the application. This is a very bad concept when you have lot of data operations. Particularly in transactional situations, the app will get performance bottlenecks.   In the second method, you'll be using a common practice of opening a connection just before usage and closing it. Note that when you close any connection, the connection will not be destryed but it will be returned back to connection pool. For any .NET managed data provider the connection pooling will be done automatically and by default.   I suggest you to use Microsoft Application Blocks for Data Access rather than re-inventing the wheel. These application blocks are designed and developed carefully by Microsoft Patterns & Practices Team and highly optimized for data access.     HTH Sudhakar Sadasivuni Microsoft MVP , MCSD http://weblogs.asp.net/ssadasivuni       View other groups in this category. Also on MSN: Start Chatting | Listen to Music | House & Home | Try Online Dating | Daily Horoscopes To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. Need help? If you've forgotten your password, please go to Passport Member Services. For other questions or feedback, go to our Contact Us page. If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. Remove my e-mail address from dotNET User Group Hyd.