A code smith template to create: stored procedures, business class, data providers, fetch access control
-To use copy 'DatabaseScehma' folder to the codesmith installation path : { windows user folder }\Documents\CodeSmith Generator\Templates
-Rightclick on 'start.cst' and click on 'execute'
-Fill parameters and click on 'Generate' button
-Check output path template creates classes from database to use in your project
-execute 'AllStoredProcedures.cst'
-Fill Parametters
-Click On Generate