At XpresServers, we constantly strive to deliver total customer satisfaction with all our hosting services. That’s why we offer fast, reliable and secure service that’s backed by our friendly, knowledgeable support team, 24/7.

ASPNET

The author selected the Open Source Initiative to receive a donation as part of the Write for DOnations program.

Introduction

ASP.NET Core is a high-performant, open-source framework for building modern web applications, meant to be a more modular version of Microsoft’s ASP.NET Framework. Released in 2016, it can run on several operating systems such as Linux and macOS. This enables developers to target a particular operating system for development based on design requirements. With ASP.NET Core, a developer can build any kind of web application or service irrespective of the complexity and size. Developers can also make use of Razor pages to create page-focused design working on top of the traditional Model-View-Controller (MVC) pattern.

ASP.NET Core provides the flexibility to integrate with any front-end frameworks to handle client-side logic or consume a web service. You could, for example, build a RESTful API with ASP.NET Core and easily consume it with JavaScript frameworks such as Angular, React, and Vue.js.

In this tutorial you’ll set up and deploy a production-ready ASP.NET Core application with a MySQL Server on Ubuntu 18.04 using Nginx. You will deploy a demo ASP.NET Core application similar to the application from Microsoft’s documentation and hosted on GitHub. Once deployed, the demo application will allow you to create a list of movies and store it in the database. You’ll be able to create, read, update, and delete records from the database. You can use this tutorial to deploy your own ASP.NET Core application instead; it’s possible you’ll have to implement extra steps that include generating a new migration file for your database.

Prerequisites

You will need the following for this tutorial:

Step 1 — Installing .NET Core Runtime

A .NET Core runtime is required to successfully run a .NET Core application, so you’ll start by installing this to your machine. First, you need to register the Microsoft Key and product repository. After that, you will install the required dependencies.

First, logged in as your new created user, make sure you’re in your root directory:

Next, run the following command to register the Microsoft key and product repository:

To facilitate the installation of other packages required for your application, you will install the universe repository with the following command:

sudo add-apt-repository universe

Next install the apt-transport package to allow the use of repositories accessed via the HTTP Secure protocol:

sudo apt install apt-transport-https

Now, run the following command to download the packages list from the repositories and update them to get information on the newest versions of packages and their dependencies:

Finally, you can install the .NET runtime SDK with:

sudo apt install dotnet-sdk-2.2

You will be prompted with the details of the size of additional files that will be installed. Type Y and hit ENTER to continue.

Now that you're done installing the .NET Core runtime SDK on the server, you are almost ready to download the demo application from GitHub and set up the deployment configuration. But first, you'll create the database for the application.

Step 2 — Creating a MySQL User and Database

In this section, you will create a MySQL server user, create a database for the application, and grant all the necessary privileges for the new user to connect to the database from your application.

To begin, you need to access the MySQL client using the MySQL root account as shown here:

You will be prompted to enter the root account password, set up during the prerequisite tutorial.

Next, create a MySQL database for the application with:

CREATE DATABASE MovieAppDb;

You will see the following output in the console:

Output

Query OK, 1 row affected (0.03 sec)

You've now created the database successfully. Next, you will create a new MySQL user, associate them with the newly created database, and grant them all privileges.

Run the following command to create the MySQL user and password. Remember to change the username and password to something more secure:

CREATE USER 'movie-admin'@'localhost' IDENTIFIED BY 'password';

You will see the following output:

Output

Query OK, 0 rows affected (0.02 sec)

To access a database or carry out a specific action on it, a MySQL user needs the appropriate permission. At the moment movie-admin does not have the appropriate permission over the application database.

You will change that by running the following command to grant access to movie-admin on MovieAppDb:

GRANT ALL PRIVILEGES ON MovieAppDb.* TO 'movie-admin'@'localhost';

You will see the following output:

Output

Query OK, 0 rows affected (0.01 sec)

Now, you can reload the grant tables by running the following command to apply the changes that you just made using the flush statement:

You will see the following output:

Output

Query OK, 0 rows affected (0.00 sec)

You are done creating a new user and granting privileges. To test if you are on track, exit the MySQL client:

Log in again, using the credentials of the MySQL user you just created and enter the appropriate password when prompted:

Check to be sure that the user movie-admin can access the created database, check with:

You've created a database, made a new MySQL user for the demo application, and granted the newly created user the right privileges to access the database. In the next section, you will start setting up the demo application.

Step 3 — Setting Up the Demo App and Database Credentials

As stated earlier, you'll deploy an existing ASP.NET Core application. This application was built to create a movie list and it uses the Model-View-Controller design pattern to ensure a proper structure and separation of concerns. To create or add a new movie to the list, the user will populate the form fields with the appropriate details and click on the Create button to post the details to the controller. The controller at this point will receive a POST HTTP request with the submitted details and persist the data in the database through the model.

You will use Git to pull the source code of this demo application from GitHub and save it in a new directory. You could also download an alternate application here if you will be deploying a different application.

To begin, create a new directory named movie-app from the terminal by using the following command:

sudo mkdir -p /var/www/movie-app

This will serve as the root directory for your application. Next, change the folder owner and group in order to allow a non-root user account to work with the project files:

sudo chown sammy:sammy /var/www/movie-app

Replace sammy with your sudo non-root username.

Now, you can move into the parent directory and clone the application on GitHub:

You have successfully cloned the demo application from GitHub, so the next step will be to create a successful connection to the application database. You will do this by editing the ConnectionStrings property within the appsettings.json file and add the details of the database.

With this in place, you've successfully created a connection to your database. Now press CTRL+X to save your changes to the file and type Y to confirm. Then hit ENTER to exit the page.

ASP.NET Core applications use a .NET standard library named Entity Framework (EF) Core to manage interaction with the database. Entity Framework Core is a lightweight, cross-platform version of the popular Entity Framework data access technology. It is an object-relational mapper (ORM) that enables .NET developers to work with a database using any of the database providers, such as MySQL.

You can now update your database with the tables from the cloned demo application. Run the following command for that purpose:

dotnet ef database update

This will apply an update to the database and create the appropriate schemas.

Now, to build the project and all its dependencies, run the following command:

This will build the project and install any third-party dependencies listed in the project.assets.json file but the application won’t be ready for production yet. To get the application ready for deployment, run the following command:

This will pack and compile the application, read through its dependencies, publish the resulting set of files into a folder for deployment, and produce a cross-platform .dll file that uses the installed .NET Core runtime to run the application.

By installing dependencies, creating a connection to the database, updating the database with the necessary tables, and publishing it for production, you've completed the setup for this demo application. In the next step you will configure the web server to make the application accessible and secure at your domain.

Step 4 — Configuring the Web Server

By now, having followed the How To Secure Nginx with Let's Encrypt tutorial, you'll have a server block for your domain at /etc/nginx/sites-available/your_domain with the server_name directive already set appropriately. In this step, you will edit this server block to configure Nginx as a reverse proxy for your application. A reverse proxy is a server that sits in front of web servers and forwards every web browser’s request to those web servers. It receives all requests from the network and forwards them to a different web server.

In the case of an ASP.NET Core application, Kestrel is the preferred web server that is included with it by default. It is great for serving dynamic content from an ASP.NET Core application as it provides better request-processing performance and was designed to make ASP.NET as fast as possible. However, Kestrel isn't considered a full-featured web server because it can't manage security and serve static files, which is why it is advisable to always run it behind a web server.

To begin, ensure that you are within the root directory of your server:

Open the server block for editing with:

sudo nano /etc/nginx/sites-available/your_domain

As detailed in the Step 4 of the How To Secure Nginx with Let's Encrypt tutorial, if you selected option 2, Certbot will automatically configure this server block in order to redirect HTTP traffic to HTTPS with just a few modifications.

Continue with the configuration by editing the first two blocks in the file to reflect the following:

The configuration in this server block will instruct Nginx to listen on port 443, which is the standard port for websites that use SSL. Furthermore, Nginx will accept public traffic on port 443 and forward every matching request to the built-in Kestrel server at http://localhost:5000.

Finally, following the server block you just edited in the file, ensure that the second server block looks like so:

This server block will redirect all requests to https://your-domain and https://www.your-domain to a secure HTTPS access.

Next, force Nginx to pick up the changes you've made to the server block by running:

With the Nginx configuration successfully completed, the server is fully set up to forward all HTTPS requests made to https://your-domain on to the ASP.NET Core app running on Kestrel at http://localhost:5000. However, Nginx isn’t set up to manage the Kestrel server process. To handle this and ensure that the Kestrel process keeps running in the background, you will use systemd functionalities.

Systemd files will allow you to manage a process by providing start, stop, restart, and log functionalities once you create a process of work called a unit.

The configuration file specifies the location of the project’s folder with WorkingDirectory and the command to execute at the start of the process in ExecStart. In addition, you've used the RestartSec directive to specify when to restart the systemd service if the .NET runtime service crashes.

Now save the file and enable the new movie service created with:

sudo systemctl enable movie.service

After that, proceed to start the service and verify that it’s running by starting the service:

This output gives you an overview of the current status of the movie.service created to keep your app running. It indicates that the service is enabled and currently active.

Navigate to https://your-domain from your browser to run and test out the application.

You'll see the home page for the demo application—Movie List Application.

With the reverse proxy configured and Kestrel managed through systemd, the web app is fully configured and can be accessed from a browser.

Conclusion

In this tutorial, you deployed an ASP.NET Core application to an Ubuntu server. To persist and manage data, you installed and used MySQL server and used the Nginx web server as a reverse proxy to serve your application.

Beyond this tutorial, if you're interested in building an interactive web application using C# instead of Javascript you could try a web UI framework by Microsoft called Blazor. It is an event-driven component-based web UI for implementing logic on the client side of an ASP.NET Core application.

If you wish to deploy your own application, you'll need to consider other required procedures to deploy your app. The complete source code for this demo application can be found here on GitHub.