Query Object Pattern with Stored Procedures?

Topics: Developer Forum
Feb 24, 2010 at 1:22 PM

OR/Ms and Dynamic SQL are the source of all evil, at least, that's what any good DBA would say ;-)

It's there any logical/simple implementation possible for using the Query Object pattern in combination with Stored Procedures?
Or should you look for another pattern for the DAL when using Stored Procedures? 

Coordinator
Mar 31, 2010 at 8:55 AM

The simplest answer I can tell you is: have the query exposed to the application as a method exposed by the repository, and then have the method implementation calling the SP