The C.R.U.D. Template Wizard is accessed by clicking on the main toolbar:
When kiss!® is installed and run for the first time, System Templates (SQL, C# & VB.Net) are set up. These cannot be renamed as they are used in the C.R.U.D. Template Set Up Wizard.
DAL, BLL, Value Objects & Web Service Templates are designed to use Base Classes. System Templates can be modified to not used Base Classes if required:
Set up optional Table Manifest (Code & SQL) Defaults in Tools | Options: Defaults:
The C.R.U.D. Template Set Up Wizard appears as below accessed via on the main toolbar.
Select Code Language, Result Type, Web Services and Templates if required. Database Type is set to the Database Type of the current Data Model Database.
Selections and entries are saved for the next iteration.
Templates for Layers and Namespaces are assigned by the system:
Templates for Objects and Namespaces are assigned by the system:
Templates for Web Services (ASP.Net), WCF & WCF RESTful JSON Services and Namespaces are assigned by the system:
Templates for Table & Field Enumerations and Namespaces are assigned by the system:
Step 1: Select required Code Language (C# or VB.Net), Dataset or Value Object Results, Templates, Placeholders, Options then click "Next":
Step 2: Add, Modify or Accept Table Manifest Defaults (as set in Options here showing test data) then click "Next":
Step 3: Additional Table Manifest settings and validation. Select Tables using a Table Set (if configured), individually or "Select All":
Select existing Stored Procedures individually or "Select All":
Select existing Views individually or "Select All", then click "Finish":
Return to the main form and click "Generate":
Once complete the required SQL C.R.U.D. stored procedures, Data Access Layer (DAL), Business Logic Layer (BLL), Value Objects and Web Services will be available in the relevant locations to add to your Visual Studio Solution:
Set the Target Database Name Placeholder to the name of the Test Database (see Placeholders):
Test SQL against the Test Database: