I think most people arguing about stored procedures are missing the point. The most important aspect revolves around a clear separation of concerns.
- “At just about every talk I give I always try to make several consistent statements. One of which is: â€˜Whenever possible use stored procedures to access your dataâ€™.” - Rob Howard’s Blog
- “Let me start with a blunt statement: stored procedures are bad, they are a bad way to formulate data-access logic. ” - Frans Bouma’s blog
- “In my experience, this debate comes down to a mindset. If you are fundamentally database-focused, you will like stored procedures. If you are fundamentally application-focused, you will not.” - Ned Batchelder
- “. . . one of the ways we solve this problem is by using the provider model pattern: a pluggable data access layer” - Rob Howard’s Blog
- “However the alternative is not stored procedures, it’s a component . . .” - Frans Bouma’s blog
In an upcoming post I’ll try to find some code that shows how your business logic can leak across boundries without your realizing it.