Developing .NET solutions on Linux has always been challenging because Microsoft’s Visual Studio requires Windows to operate. After working on several .NET projects, I decided to test the limits of .NET development on Linux. This simple tutorial focuses on creating an ASP.NET MVC application with SQL Server to demonstrate how elegant and effective .NET development can be on my preferred OS.

Development Environment

First, ensure the .NET tools and SDK associated with your particular flavor of Linux are installed using Microsoft’s standard guide.

My preferred development environment consists of a windowed integrated development environment (IDE), a powerful database management and query tool, the database itself, and tools for building and deployment. I use the following tools to achieve solid functionality and enable a beautiful coding experience:

• IDE: Visual Studio Code
• Database Management and Query Tool: DBeaver
• Database: Microsoft SQL Server (Linux Installation)
• Build Tools: .NET SDK Command Line Interface (CLI)
• Virtual Machine and Containers: Docker

Make sure these tools are properly installed before you proceed with our sample application.

Project Scaffolding

In this sample application, we’ll highlight ASP.NET development and functionality through a series of use cases for a hypothetical shoe store inventory management system. As with any new .NET application, we’ll need to create a solution and then add a project to it.