Justin FINALLY got around to learning how to use Codesmith. I have only been trying to get him to do that for 2 months.
I have mentioned Codesmith on the forums before as I feel compelled to let everyone know how useful this tool is. It does take a bit of getting used to, but once you have the hang of it you can save hours.
For anyone who has NO idea what I am talking about, Codesmith is a template driven code generation tool with the ability to explore your database schema. What that means is you can create templates to generate add/update/delete/select stored procs from a table. Or data access code for calling your stored procs from something else. Pretty much anywhere you are writing repetitive code, you could set up a template to do it.
Give it a go, I promise you won't look back