Generate ASP.NET Core 2.1 Razor Pages, Razor Page Models, Models, Web API, Middle-Tier, Data-Tier (linq-to-entities using the Entity Framework Core), and Stored Procedures or Ad-Hoc SQL in One Click*. AspCoreGen 2.0 Razor generates databound ASP.NET Core 2.1 Razor pages. AspCoreGen 2.0 Razor is completely rewritten from the ground up just like the code it generates, the ASP.NET Core 2.1 Razor pages.

AspCoreGen 2.0 Razor is an ASP.NET Core 2.1 Razor code generator. It can generate code in C#. It generates code by looking at your Microsoft SQL Server database tables (or views). AspCoreGen 2.0 Razor is the perfect code generator, it will generate a whole web application including a class library and a web API project in just One Click!

How It Works

AspCoreGen 2.0 Razor generates ASP.NET Core 2.1 razor pages, razor page models, middle-tier and data-tier (linq-to-entities using Entity Framework Core) objects in a 3-tier layered infrastructure. In short it generates a whole web application. It also generates stored procedure scripts or ad-hoc SQL. All these are generated in One Click*.

Shown below is a visual reprensentation/flow of how AspCoreGen 2.0 Razor generates code.



Click the "Generate Code..." button.

Retrieve Microsoft SQL Server Database information.

Generate Code: Generates three projects.

Generate an ASP.NET Core 2.1 Razor Web Application - Front End (UI - Presentation Layer).
Generate Razor Pages, Razor Page Models.
Generate styles, scripts, images, icons, web.config, etc. (not shown in the diagram).

Generate an optional Web API project
Optionally encapsulate calls to Business Objects when generating Web API code.

Generate a Business/Data Objects Class Library project
Generate Middle-Tier Class Files (Middle Layer).
Generate Data-Tier Class Files (Data Layer). See more
Generate additional files such as Models

Generate SQL Scripts.

Generate Linq-to-Entities queries (EF Core), or Stored Procedures, or Ad-Hoc SQL. Stored procedures are generated inside Microsoft SQL Server. The Linq-to-Entities queries (EF Core) or Ad-Hoc SQL scripts are generated as class files.

N-Tier Layer Approach

AspCoreGen 2.0 Razor 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. Code is separated in different layers, see below:

Front End (UI - Presentation Layer) Razor Pages, Razor Page Models, jаvascript, CSS, JQuery, etc. See more

Web API (Middle-Layer, Optional). Optionally encapsulate calls to Business Objects when generating Web API code. See more

Middle-Tier Class Files (Middle Layer) Business Logic Class Files, Models, etc. See more

Data-Tier Class Files (Data Layer) using Linq-to-Entities - Entity Framework Core or Ad-Hoc SQL. See more

SQL Scripts (Stored Procedures). See more

The generated middle tier objects (and data tier objects) is generated in another application (class library project) and can also be 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 are calls using Linq-to-Entities, or Stored Procedures, or Ad-Hoc SQL. Linq-to-Entities, or Stored Procedures, or Ad-Hoc SQL are also generated so you don't have to worry about writing T-SQL commands.



Generated Projects

AspCoreGen 2.0 Razor generates 3 projects/applications in One Click! It generates 3 separate applications in one Solution. The separation of projects is another way to clearly distinguish the functionality of the respective applications.

Web Application Project: This is the ASP.NET Core Razor application which mostly contains UI components, or the Presentation Layer.

Razor Pages
Razor Page Models
Partial Razor Pages
Partial Razor Page Models
Stylesheets
Images
jаvascript scripts and libraries
Code Examples
Miscellaneous files that completes an ASP.NET Core web application

Class Library Project: This is the API application that contains the Middle and Data Tier code which is shared between the Web Application and Web API.

Business Objects (Middle Tier .cs class files)
Data Layer using Linq-to-Entities (Data Tier .cs class files)
Enum Files
Entity Framework Entities or Ad-Hoc SQL
Miscellaneous files that completes a Class Library application

Web API Project: This is the optional Web API application.

Controllers
Miscellaneous files that completes a Web API application

Stored Procedures: Not a project. These are SQL scripts directly generated in your Microsoft SQL Server.

Only for V.I.P