Stored Procedures and ORMS can live Together

As a software consultant I often walk into shops and see two approaches to data access. First is the all stored procedure approach. The reasoning is typically “ORMs take control of away from the DBA”. Ok. I’m sure your DBA loves writing single insert statement store procedures … Second is “the ORM all the way or the highway approach”. These guys (and gals) refuse to use stored procedures. Stored procedures are viewed as a relic. When faced with a problem that screams stored procedure. A SQL solution is crafted and stored in the ORM’s XML configuration because XML is a better place for SQL than the database…