Tod1d's Thought Process

These templates have been improved. Checkout version 2.0 of these CodeSmith templates. 

This is a collection of CodeSmith templates that I use on a regular basis.

Requirements:
 - .NET 2.0
 - CodeSmith 2.6 (Freeware version available here: http://www.codesmithtools.com/freeware.aspx)
 - Your database tables to use INT type as primary key.

Instructions:

 1. Create a project new class library project in Visual Studio 2005. I normally name mine with suffixed with "Lib" (e.g. MyAppLib).
 2. Add SQLHelper.cs, DataEntityBase.cs, and DataEntityBaseList.cs to your project.
 3. Create your stored procs using Tod1d_StoredProcedures.cs and add them to your database.
 4. Create your classes using Tod1d_ClassLibrary.cst. The only required field is SourceTable. Follow the instructions in the generated code.

Recent enhancements:

 - Instructions included with code that generates the classes.

 - Less copy and pasting.

 - Support for 'list' tables. An example of a 'list' table would be a table used to store data that fills a dropdown. (i.e. States). Tables where you want to return all records.