Take the tedium out of coding CRUD stored procedures and use this enhanced code generator crud_generator instead. It’s the one from www.sqlbook.com with the following enhancements:
1) Suffixes changed to Search, Load, Save and Delete
2) Generates a comment header for each procedure
3) Generates default values when null parameters supplied to Save procedure
4) Uses char(13) + char(10) for new lines
This is a great way to jump start your coding after your data model is finalised. Then use Dapper to build your c# data access layer. Job done.