T4 code generation has been on my short list of things to look into but keeps getting put off as i navigate down some other endless path. Meanwhile, I found a nice article on using T4 to generate stored procs for CRUD operations for the Entity Framework.
Entity Framework Stored Procedure Generation
Thanks David.