Code Gen.
What is your favorite Code Generator? We use LLBLGen Pro. We did use CodeSmith and it worked good. A few months ago we bought a copy of LLBLGen and have absolutely worn it out ever since. If you need a MS SQL Dot Net code generator I highly recommend trying this product. Here is a link to their site http://www.llblgen.com.