|
|
|
|
|
|
|
|
Saturday, July 31, 2010
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
These FREE CodeSmith templates for DNN 4.x have been enhanced to provide an even easier experience for you to generate your Data Access Layer for DotNetNuke development.
In this download, you'll find:

DNN Controller Class Generator Template
Class Setup
- Configure Basic CRUD Operations with Prefix Options
- Namespace Setup
- StripText
- optionally strip text from your table names to build the class names. For example, if your table were named VE_MyTable, you could use "VE_" as the StripText and the generated class names would be "MyTable". If you use the StripText on your Info Class Generator Templates, you should use the same text here or the classes will lose their "connection" to each other.
Context
- Select the source table to base the Controller Class on
Options
- Choose to include Controller Methods to Delete, Get, Insert, List, Update objects
- Choose to include code structure for DNN API implementations of ISearchable and IPortable

DNN Info Class Generator Template
Class Setup
- Namespace Setup
- StripText
- optionally strip text from your table names to build the class names. For example, if your table were named VE_MyTable, you could use "VE_" as the StripText and the generated class names would be "MyTable". If you use the StripText on your Controller Class Generator Templates, you should use the same text here or the classes will lose their "connection" to each other.
Context
- Select the source table to base the Controller Class on

DNN Stored Procedure Generator Template
Context
- Select the source table(s) to base the stored procedures on. Once you have created your base tables, you can select one or more at a time, and the template will generate all the basic CRUD operation proedures for you. (Get, List, Create, Read, Update, Delete) for each table.
Options
- Namespace Setup
- StripText
- optionally strip text from your table names to build the class names. For example, if your table were named VE_MyTable, you could use "VE_" as the StripText and the generated class names would be "MyTable". If you use the StripText on your Controller Class Generator Templates, you should use the same text here or the classes will lose their "connection" to each other.
Sproc Setup
- Select the prefix names that you prefer to use for your CRUD operations. Some people like "Get" some prefer "Fetch". Some like "Create", some like "Add". You pick your preference!
- Also, you can optionally add an object Qualifier. Thiswill be appended to the beginning of each procedure. This does not replace the required " {databaseOwner}{objectQualifier}" required by DNN development guidelines. Please note, this is already included as part of the template)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|