AspxFormsGen MVC 5. Generate ASP.NET MVC 5 (Razor) Models, Views, Controllers, View Models, Web API, Middle-Tier, Data-Tier, and Stored Procedures (or Ad Hoc/Dynamic SQL) in One Click*. AspxFormsGen MVC 5 generates databound ASP.NET MVC 5 Objects. AspxFormsGen MVC 5 is a combination of our AspxFormsGen engine (generates MVC 5 (Razor) Views) and AspxCodeGen 4.5 engine which generates Middle-Tier, Data-Tier, and Stored procedures or Ad-Hoc/Dynamic SQL codes.

Generated MVC views are bound by strongly-typed middle tier objects that encapsulates data-tier functionalities. Objects generated by AspxCodeGen 4.5 engine are called by the generated MVC 5 (Razor) Views, and can be used as stand-alone API.

How It Works
AspxFormsGen MVC 5 generates ASP.NET MVC 5 models, views, controllers, middle-tier and data-tier objects in 3-tier layered infrastructure. In short it generates a whole web application. It also generates stored procedures or ad-hoc/dynamic SQL scripts. All these are generated in One Click*. Shown below is a visual reprensentation/flow of how AspxFormsGen MVC 5 generates code.




Click the "Generate Code..." button.

Retrieve Microsoft SQL Server Database information.

Generate a database-bound Web Application. The web application is generated so you can run it and see the generated code in action.

Generate Front End (UI - Presentation Layer) Models, Views, View Models, Controllers.
Generate Web API (Optional). Optionally encapsulate calls to Business Objects when generating Web API code. See more
Generate Middle-Tier Class Files (Middle Layer).
Generate Data-Tier Class Files (Data Layer).
Generate SQL Scripts (Stored Procedures or Ad-Hoc/Dynamic SQL in Class Files).
Generate styles, scripts, images, icons, web.config, etc. (not shown in the diagram).
Generate Stored Procedures in your database (Microsoft SQL Server), or, generate Ad-hoc/Dynamic SQL Class Files.

N-Tier Layer Approach

AspxFormsGen MVC 5 generates code in a 3-tier (n-tier) architecture. A presentation tier (the client), middle tier (business objects), data tier (data access objects), and the database scripts such as stored procedures or a-hoc/dynmamic sql. Code is separated in different layers, see below:

Front End (UI - Presentation Layer) Models, Views, View Models, Controllers.
Web API (Middle-Layer, Optional). Optionally encapsulate calls to Business Objects when generating Web API code.
Middle-Tier Class Files (Middle Layer).
Data-Tier Class Files (Data Layer).
SQL Scripts (Stored Procedures or Ad-Hoc/Dynamic SQL in Class Files).

The generated middle tier objects (and data tier objects) can be put in another project and consumed by other clients. Clients could be a web form (.aspx), a win form, or a web service (.asmx, wcf), etc. Or better yet you can choose to generate the Web API (optional) and get all the other clients to access this extra layer instead.

The middle tier encapsulates all calls to the data access objects (data tier) so that calling a CRUD (create, retrieve, update, delete) and other operations are very easy and may only take one line of code for most parts. We made it even easier by generating and showing an example for each CRUD operation, for each table in your database, so you just copy and paste a call from your chosen client.

The data tier encapsulates all calls to the database. These could be calls to Stored Procedures or Dynamic SQL. Stored Procedures or Dynamic SQL are also generated so you don't have to worry about writing T-SQL commands.



Generated Presentation (UI) Layer
Listed below are quick descriptions of the ASP.NET MVC Models, Views, Controllers, and View Models AspxFormsGen MVC 5 generates that makes up the Presentation Layer (Front End). Note: All generated views with a grid also have paging and sorting functionality. CRUD are database operations which means: create (add a new record), retrieve (get an existing record), update an existing record, delete an existing record.

Generated Web API
Listed below are quick descriptions of the Web API controller class files AspxFormsGen MVC 5 generates. These Web API methods encapsulates calls to the Middle Layer methods. Generating Web APIs are optional. Web APIs can be a client and act as another middle layer. Generated Web API methods can be accessed publicly and can act as a service to other clients (winforms, web forms, other api or service like a wcf app, mobile app, etc). So you can also build a desktop app that can access the same API your MVC app is using through the Web API. Clients/consumers of the Web API does not have to be a windows program, it returns collections as JSON data, or you can pass it JSON data when saving a new record or updating an existing record.

Generated Middle Layer
Listed below are quick descriptions of the Business Object class files AspxFormsGen MVC 5 generates that makes up the Middle Layer (Middle Tier). In a 3-tier infrastructure, middle layer code is called by the UI or presentation layer code. It can contain business computations applicable to the application's purpose. It also contains calls to the data layer code.