Rob tweeted:
This thread is a fucking embarrassment for all .NET developers (read toward the end) groups.google.com/group/subsonic…
And it is. Poor guy is having some performance problems with SubSonic compared to Entity Framework when loading 1 million rows in his application. Then he goes to say he’d rather quit than use inline SQL to get better performance.
Pretend you’re in that situation. Your building some analytic fat client application that shoves fancy dashboards in the faces of middle managers so they can maybe make better business decisions. Would they care that you used a bit of inline SQL to gain some performance? Would they care that you use an ORM? I’m going to go out on a limb and say that they wouldn’t. They want their dashboards and whiz bang analytics to work and work well and perform well. You know, the stuff that you’re actually supposed to be delivering.
Im all for ORMs and clean code and patterns and SOLID and software craftsmanship but like most things, they’re best in moderation. There are exceptions to every piece of guidance/pattern/scenario out there.
An unwillingness to accept a given solution does not mean that the solution does not exist. Solve the right problems. You are not your code.