• If you have your databases in an SSDT database Project you can use T4 templates to generate CRUD procedures.  I've also used written T-SQL to generate them, but since I try to always have my databases in database projects and source control, I now prefer T4 templates in SSDT.  Here's a link to a presentation I do on it and it has examples.