This video shows how to create a simple template for generating stored procedures based on a database table.
This video shows you how to create a Data Access Layer using CodeSmith and the .NetTiers templates in 15 minutes or less.