Welcome to kiss!® by Cove Bay Software Limited. Hybrid C#, VB.Net code generation and SQL script management (Microsoft SQL Server, Azure & MySQL 5.6) for the real world.
kiss!® is a .NET Development Code Generation Manager.
kiss!® generates Object Relational Mapping (ORM) Data Access and Business Logic Layers including Create, Read, Update & Delete (CRUD) SQL Scripts and Web Services (ASP.NET, WCF and WCF RESTful JSON) from a Data Model Database tables.
Once all generation has been done kiss!® acts as a Script & Code File Manager. SQL Scripts can be Concatenated and Executed against a SQL Server or MySQL Test and / or Deployment Database.
kiss!® generates SQL ALTER Scripts for the most frequent development actions: Add (Table & Field), Drop (Table & Field), Rename (Table & Field) and Change Field Data Type, Add, Drop, Rename, Alter Stored Procedure or View.
Please note: For the best results in SQL and Code Generation please ensure that all tables have a Primary Key and IDENTITY Column.
Tables in the Data Model Database are used to generate C.R.U.D. Stored Procedures and related code including JSON Web Services.
Existing Stored Procedures and Views in the Data model Database are used to produce code (except JSON Web Services) enabling them to be called pragmatically.
The supplied Templates can be customised but will work "out of the box".
kiss!® has Templates to generate the following in C# and VB.NET:
1.Business Logic Layer (BLL, BLO) delivering Object Relational Mapping (ORM).
3.Data Access Layer (DAL, DAO) delivering Object Relational Mapping (ORM).
4.Domain Objects (DO).
6.Domain Manager Objects (MO).
8.Transfer Objects (TO).
9.Value Objects (VO) also known as Data Transfer Objects (DTO) or Plain Old CLR Object (POCO). VO = DTO = POCO.
10.Value Object Interfaces.
11.Web Services (WS, WCF, WCFRJSON) for ASP.NET, WCF and WCF RESTful JSON (C.R.U.D. only for JSON, currently not existing Stored Procedures & Views).
The following Stored Procedures are generated with the supplied SQL Templates and are wrapped by the Data Access Layer, Business Logic Layer, Web Services (ASP.Net), WCF and WCF RESTful JSON Services:
1.Insert: Insert a record.
2.InsertOutputIdentity: Insert a record and have the Auto IDENTITY returned.
3.SelectID: Select a record by the Primary Key.
4.SelectAll: Select all records from the table.
5.SelectAllOrderByPrimaryKey: Select all records from the table ordered by the Primary Key.
6.Update: Update a record by the Primary Key.
7.Delete: Delete a record by the Primary Key.
8.SelectByForeignKey: Select all records from the table by any of the Foreign Keys if applicable.
9.DeleteByForeignKey: Delete all records from the table by any of the Foreign Keys if applicable.
Data Access Layer, Business Logic Layer, Web Services (ASP.Net), WCF Services can be generated for Existing Stored Procedures and Views. WCF RESTful JSON Services are not currently generated for Existing Stored Procedures and Views.
Class Diagrams for the Custom Error Manager and generated classes are available here.
kiss!® creates Base and Custom Partial classes which can be modified by the user but are not overwritten in the next Generation Cycle unlike the Manifest Classes which are regenerated in each iteration:
kiss!® sits at the centre of the rapidagiledevelopment.com product suite: