View Image

C# VB.Net SQL template driven Code Generator from a Database Data Model with Reverse Engineering to SQL Scripts. Execute, Test groups of SQL Scripts and produce SQL Patch Scripts. Concatenate file groups hierarchically with Placeholder substitution. Hybrid (generated and manual) SQL Script management. Modify existing or create new Templates and Placeholders to customise generated output. Generate Web Services, Table and Field Enums for use in DataSet field access. Basic database schema export and SQLMetal genaration. kiss! is a .Net Development Code Generation Manager. kiss! generates Data Access and Business Logic Layers including Create, Read, Update & Delete (C.R.U.D.) SQL Scripts and Web Services from a Data Model Database. Once all generation has been done kiss! acts as a Script & Code File Manager. SQL Scripts can be Concatenated and Executed seamlessly against a SQL Server Test Database. kiss! has Templates to generate the following in C# and VB.NET: Business Logic Layer (BLL, BLO) Convert Class (VO -> TO; TO -> VO) Data Access Layer (DAL, DAO) Domain Objects (DO) Domain Object Managers (MO) Field Enumerations Table Enumerations Transfer Objects (TO) Value Objects (VO), also known as Data Transfer Objects (DTO) Web Services (WS) Iterative Development Cycle overview: Adjust Data Model Database: Changes to the Data Model are implemented in the Data Model Database. Synchronise kiss!: Changes in the Data Model Database must be synchronised in kiss! by Validating Table Manifests and Synchronising the Data Model. Validate Table Manifest(s): Check Table Manifests shown in red for fields to be added to Data Model Generate Code & SQL: When kiss! has finished synchronising new Code & SQL can be generated to take account of the Data Model. Execute SQL on Test Database: When Code & SQL have been generated SQL (both generated and manual SQL scripts) can be tested against the Test Database.