The current project I'm working on is based on VB6, using a lot of inline SQL statements... My job is to come up with a POC for a redo in C# 2008 (ASP.NET). I'm thinking of using ES to get a head start with the DAL and Business Entities. One of the issues I'm facing is the following: A customer logs in and through a default connection a lookup is ...

I'm caching the collections for my lookup tables (data that does not change) and I was wondering if there was a way to disconnect the ADO to free up resources. http://www.topxml.com/conference/wrox/1999_dc/Powerpoints/256,1,Disconnecting

I'm having a problem changing between different ES connections. I have read many posts regarding how to create configless connections and switch between them, but all of them use the DefaultConnection property to do so. For my business problem, I cannot use the ES default connection. I am writing a base Framework which will be consumed by other ...