Introduction
The attached application helps developers to save time and effort in creating N-tier applications.
It creates stored procedures, adds data, data access layer, business layer and web pages in ASP.NET version and all layers works with C# and data, data access layer, business layer with c# and vb.net.
The system has code template for each layer then according to the selected language it create properties and events and methods then find the properties region or method region and replace the region in templates with the code then save it as files for selected layer
How to Use Steps:
-
Set Connection, output folder and language settings
Select C# as a language;
check Use Data Object so the methods take one object as parameter (its recommendation to set primary key name table name + "Id"
-
Click Get Tables to retrieve all tables schema
-
Go to Generate stored procedure tab and click generate In this step the application will get saved stored procedure template then loop on database tables and get table name then replace #Table Name# with the table name in the template and save it as sql file
-
Go to Generate data objects tab and click generate in this step the application get the data object template for selected language and put fields and variables according to the selected language Vb or C#
-
Go to Generate data access layer tab and click generate the same as the previous step but it read from DAL Template according to the selected language and create method parameters and return types then create the new DAL Class for each table in selected database
-
Go to Generate business layer tab and click generate using the bus template
-
Go to Generate web layer (GUI) tab and click generate in this step the application generate master page ,base web form and for each table it generate details page and list
---- page the details page contain textbox ,required validation ,save and delete button the detail page works in two modes (Insert new item and update exists data)
---- list page contain the list of all data in the table in data grid view and edit link in each row to open detail page in edit mode
The DB Manager Class
Used to get tables and columns schema and required columns and primary keys and foreign keys
The File Manager
Used to manage templates and layers files to create files from templates and save it in selected output folder
Download and run the attached application for more details.