Right now the company I work for is using Microsoft enterprise library very extensively. From what I've found online recently, these database objects aren't intended for web (asp) usage, and are relatively bloated. I don't know how accurate my research is, but I do know we have optimization problems in our Website. I know optimization is subject to personal opinion, as well as what specific task your trying to accomplish, and what your willing to trade off for the gain you need.
I'm looking for a nice balance of overall memory usage and speed. What methods does the community recommend? We only use MSSQL server, though depending on the client, it could be any version 2005 or newer.
Personally, I use the .NET built in SqlClient class.