In the ASP.NET Core series, we are going to go through a detailed example of how to use .NET Core, Angular, and MySQL for ASP.NET Core web application development.
If someone asks: “Why this combination of technologies”, without getting into too much detail, the answer would be:
- The technologies are free of charge
- Applications can be deployed on both Windows and Linux OS
- Production-grade performance
- … And because we like it 🙂
What are We Going to Do in This Guide?
We are going to use MySQL as our database. First, we are going to install the MySQL server, create tables, and populate them with some data.
Then, we will step into the world of ASP.NET Core Web API development. It is going to be our server-side part of the application. As we progress through the ASP.NET Core series, we are going to use repository pattern, generics, LINQ, Entity Framework Core, and create more projects and services to demonstrate some good practices. Overall we will try to write the application as we would in the real-time environment. Furthermore, you will learn about ASP.NET Core architecture and code organization, so you can make it more readable and maintainable.
There are three approaches to using Entity Framework:
- Database First
- Code First
- Model First
In this tutorial, we will use the Database First approach, because we want to create our database before typing the .NET code. This approach is good when you know the structure of your database beforehand, and we get to use the visual editor which makes creating relationships between tables much more straightforward.
After we finish the ASP.NET Core series, we are going to introduce three of the most popular client frameworks (Angular, React, or Vue.js) to consume our Web API. This will result in the creation of a full-stack web application.
In the end, we are going to publish our app on both Windows and Linux OS and finish strong by completing the entire development cycle.
Prerequisites:
- MySQL server installed on your machine (installation guide)
- .NET SDK
- Visual Studio 2022
Background
- Basic C# knowledge
- Intermediate C# knowledge
Basic ASP.NET Core Web API:
- SQL Server With ASP.NET Core: Creating the Database
- Service Configuration in ASP.NET Core Web API With Extension Methods
- NLog in ASP.NET Core Web API: Logging to a File
- Repository Pattern in .NET Core Web API
- ASP.NET Core Web API GET Requests With a Repository
- POST, PUT, and DELETE in ASP.NET Core Web API
Advanced ASP.NET Core Web API Concepts:
- Pagination in ASP.NET Core Web API: How to Implement Paging
- Filtering Data in ASP.NET Core Web API
- Searching in ASP.NET Core Web API With Query Parameters
- Sorting in ASP.NET Core Web API With a Dynamic OrderBy
- Data Shaping in ASP.NET Core Web API
- HATEOAS in ASP.NET Core Web API
ASP.NET Core Application Configuration:
- How to Use IConfiguration in ASP.NET Core
- Options Pattern in ASP.NET Core With IOptions
- Options Validation in ASP.NET Core
- ASP.NET Core Configuration Providers
- Custom Configuration Provider in ASP.NET Core With EF Core
- User Secrets vs Environment Variables in ASP.NET Core
Consuming ASP.NET Core Web API:
- Consuming ASP.NET Core Web API With Angular
- Blazor WebAssembly HttpClient – Consuming a Web API
- A Few Great Ways to Consume RESTful API in C#
- Using C# and DalSoft.RestClient to Consume Any REST API
Hosting ASP.NET Core Web API on different platforms:
