Kiss

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 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. 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. 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, Data Access Layer, Domain Objects, Domain Object Managers (MO) Field Enumerations Table Enumerations Transfer Objects, Value Objects (VO / DTO) Web Services. 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 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 scripts can be tested against the Test Database.