General T4 comments: I'm really impressed by T4 as a free templating tool. Don't attempt to write any templates in Visual Studio without Tangible T4 editor (free) as it helps with colour coding. You'll also need the T4 toolbox to help easily produce multi-output files, and you have to get the hang of how to derive a template from "Generator", then from "Template" and get the Include and Import statements exactly right. It took me a few hours of bumbling to get reasonably complex T4 Toolbox templates working correctly because they are so fragile and unforgiving. However, now they're really helping my productivity.
Maybe not the best thing for generating from stored procs though, as the hard part might be parsing the procs, so I'd let some other existing tool do that. Greg
