Data Access: Stored Procedures vs. ORM (ad hoc) Queries

Yet another contribution to the Stored Procedures vs Dynamic Query debate. Both a rebuttal of the Dynamic Query argument and a practical advice in favor of using the best of both worlds.