Just like the topic.
Why not use code to control stored procedures? Instead of writing stored procedures in code? ?
Stored procedures have higher performance, but for teams without a full-time dba, it is no problem to directly control stored procedures with code.