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

Hi Is there a way for caching SQL requests made to MSSQL? like I'm writing something like employee = new employee(); employee.GetByID(1);  employee2 = new employee(); employee2.GetByID(1);  will employee2 taken from the cache some way, or new SQL request for SELECT data will be made?   it's especially important if ...