I have been very pleased with CodeSmith. I wrote a template that dives into a database and creates the 4 CRUD statements for every table in the database. I am using SQL Server 2008, but it works with 2005 as well. I would be glad to share the templates with you should you decide to use codesmith.
I also use CodeSmith to generate the CF Crud screens from the stored procs. The screens are very crude (pun intended), but are a starting place for your work. CodeSmith templates are pretty easy to modify if you know a little C#. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333086 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm