I've been using CodeSmith for more than a year now, and it is one of the most valuable tools, if not *the* most valuable tool, outside of Visual Studio.  One of the things that makes CodeSmith great, in my opinion, is that you can tweak the templates (or create your own, of course) so that the final output matches your own development style.  Other code gen tools require you to conform to what they think stored procedures or a data access layer should look like.

The other cool thing about CodeSmith is that your not limited to just creating stored procedures or stubbing out business objects.  You can use CodeSmith to generate just about anything you can dream up.  Versatile and indispensable.

Oh, and very cool that they gave away a copy to all the registered attendees.

We used CodeSmith on my last project. We generated all of our collections, our entities, our data access layer, and our stored procedures. It was a service oriented architecture, and the only thing left for us to write by hand was the business layer, where most of the logic was. It does make development a ton quicker, and even if you spend twice as long writing a template as it does to write the code, the time you save in the long run is well worth it.

The part I'm not sure about is the price tag. I think I'll stay with 2.6 for now - the free version. I'm curious what 3.0 adds on that would make purchasing it worth it.

I'll be curious to see what you think of it as you start to use it.