A plea
I came across this code in a C# codebase I inherited, where all of the business logic was in the MSSQL database:
1 | default: |
Developers of the world: Please stop using stored procedures. Your application's logic belongs in your application. Stored procedures were originally meant to be used to simplify complicated operations (like math) into repeatable functions. Passing a dictionary into your database and returning what the database says is wrong in so many ways.