Rapid Agile Development for Prototyping and Rapid Application Development

Navigation: <Root level>






Main Menu > Maintenance > Templates


Templates are used for SQL Script and Code Generation. Templates are written in native SQL, C# or VB.NET and use Placeholders to substitute system generated SQL or Code.


SQL, C# and VB.NET Templates are supplied with kiss!®. Modify existing Templates or create new Templates to include custom connection string objects \ exception handling etc.


kiss!® creates Base and Custom classes which can be modified by the user but are not overwritten in the next Generation Cycle.


Use the "All" Template to see sample output for each Placeholder.


Templates cannot be deleted if they are in use by a Table Manifest.


Templates can be filtered by: Project Type, Table Manifest Type, Database Type, Class Type & Template Result Type.



SQL Templates




C# Templates




VB.NET Templates




Template Dialog


This is displayed when “New” or “Modify” are clicked. Placeholders can be added via the context menu as shown:




The Template Dialog is used to create / edit Templates. There is no SQL or Code validation but Keywords for SQL, C#, VB.NET & Data Types can by highlighted using “Format Text”.


Fields can only be changed on Templates that do not have a Template Origin of "System".


Template Origin

Determines if the Template is System or User defined.

Project Type

Select from: Code, SQL, User Defined.

Table Manifest Type

Determined by Project Type: Code: Business Logic Layer, Convert Class, Data Access Layer, Domain Objects, Table and Field Enumerations, Table Enumerations, Field Enumerations, Manager Objects, Transfer Objects, User Defined, Value Objects, WCF Service, Web Service. SQL: SQL CRUD, SQL Insert, SQL Select All, SQL Select All Order By, SQL Select All Except, SQL Select All Except Order By, SQL Update, SQL Delete, User Defined.

Template Subject

Determines what the Template is required to act on: Tables, Foreign Keys, Stored Procedures or Views

Code Language

Determined by Project Type: Code: C#, VB.Net. SQL: SQL.

Class Type

Determines what code Class the Template is used for: Base (Base Class for Inheritance), Custom (Class will not be overwritten once generated), Interface (Interface Class), Manifest (the main Class for the Table Manifest, this will be overwritten each time the Table Manifest is Generated).

Template Result Type

Result of Stored Procedures & code Method calls: Dataset, Value Objects.

Database Type

The maximum version of Database Server supported: MySQL 5.6, SQL Server 2014.


The file path of the Template.


Click to browse to the Template file.


Click to manager Placehlders.

Click to apply values to Placeholders. Note not all Placeholders can be substituted with values until actual Generation is started.

Open the Template file in a Test Editor.

Edit the Template in the Code Editor as entered in Options

Refresh dialog from file on disk.

Find & Replace.


A full list of Placeholder example values can be found in the Sample Output of this Help File.







www.rapidagiledevelopment.com by Cove Bay Software Limited Copyright © 2015