Darren,
>Hi experts, I would like to ask how to create a connection handle / handler in Visual C# using a third party software Mere Mortals. My main purpose is to avoid having unuse connection resources in SQL Server and to manage connect and disconnect.
The MM .NET data access layer automatically handles connection/disconnection to the back end database and uses ADO.NET connection pooling. In order for a connection to be reused you must have the same credentials used on the connection. Some MM .NET users hard-code the credentails on the connection (rather than using each user's credentials) on web applications to make sure connection pooling kicks in.
Best Regards,
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com