AspCoreGen 1.0. Generate ASP.NET Core 1.1 Models, Views, Controllers, View 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 1.0 generates databound AspCoreGen 1.0 Objects. AspCoreGen 1.0 is completely rewritten from the ground up just like the code it generates, the ASP.NET Core 1.1.

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

How It Works
AspCoreGen 1.0 generates ASP.NET Core 1.1 models, views, controllers, 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 1.0 generates code.



Click the "Generate Code..." button.

Retrieve Microsoft SQL Server Database information.

Generate Code: Generates three projects.

Generate an ASP.NET Core 1.1 Web Application - Front End (UI - Presentation Layer).
Generate Views, Controllers. See more
Generate styles, scripts, images, icons, web.config, etc. (not shown in the diagram). See more

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

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

Generate SQL Scripts. See more

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 1.0 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) Views, Controllers, 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, Views, View 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 1.0 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 application which mostly contains UI components, or the Presentation Layer.

Stylesheets
Images
jР°vascript scripts and libraries
Controllers
Views
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
Models
View Models
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