I just discovered CodeSmith. Regardless of the what type of development you do -- be it C#, VB.NET, ASP.NET, WinForms, SQL, ASP or even VB4, for crying out loud -- you must have this tool.
Some of you might ask, “Where have you been?! I've been using this tool for [some_unbelievably_long_period_of_time]!!!” Sure, I heard about it a long time ago. I guess I was just “too busy” to see what it was really all about.
WHY, OH WHY DIDN'T I DOWNLOAD CODESMITH SOONER?????
I never much cared for code generation tools. Usually you have to conform to someone else's idea of what a stored procedure, data class, business class, etc. should look like. CodeSmith is so much more than a code generation tool. If you can create a template for it, this sucker will crank it out. I can see now how I could automatically generate 90% of my stored procedures, data and business access layers, exactly the way I want.
I'm sitting here kicking myself, HARD, thinking about all the hours and hours of mind-numbing cut & paste / search & replace I could have saved myself over the last year using this tool. Oh, well... at least most of it was billable hours...