ASP.NET Core 3.1 MVC | EntityFrameworkCore | Visual Studio 2019 for Mac | CRUD Operations | MySQL

Today we will create an asp.net core MVC application using EntityFramework and MySQL Database with Visual Studio 2019 for Mac.

This is a simple CRUD operation for an Employe using ASP.NET Core 3.1 and EntityFrameworkCore

Prerequisites:

1. Visual Studio 2019 IDE for Mac
2. Make sure you are running the latest .Net core 3.1
3. Install the latest DOTNET and EF CLI using this command: dotnet tool install --global dotnet ef
4. MySQL database should be installed on your Mac

Getting Started:

         Open the Visual Studio 2019 for Mac and Create a New Project as below

    

     Please select the .Net Core 3.1  as below

        I created a new project with the Name, "DotNetCore" and below is the Solution structure which

        is created by VS2019.

        Let's install the few mandatory nuget packages as below

                        1. Microsoft.EntityFrameworkCore

                        2. Microsoft.EntityFrameworkCore.Design

                        3. Microsoft.EntityFrameworkCore.Tools

                        4. MySql.Data

                        5. MySql.Data.EntityFrameworkCore

        Now let's add a New Class name "DotNetCoreDbContext" under the Models folder by right-clicking

        and select Add New Class.

        Now let's write the code for this class.

        We have to inherit our class from the DbContext class by using Microsoft.EntityFrameworkCore

        

        Now let's add a New Class name "Employee" under the Models folder.

        

        

        Now add our class into DotNetCoreDbContext as below

        

        Now we need to write code for ConnectionStrings in appsettings.json file

        and modify the Startup.cs file as below

        

        Next step to add the Migration to create the Database in MySql

        Run below command w.r.t your project folder path on Terminal

        

        To Add-Migration:

        dotnet ef migrations add InitialCreate

        To Update-Database

        dotnet ef database update

        To Remove-Migration:

        dotnet ef migrations remove

        After adding the Migration, we can see our database has been created into the MySql database

        We can see our created database dotnetcore including the Employees table.

           Now let's add the controller name "EmployeeController" using Scaffolding as below

        

            

        We will use the same action for Create and Edit an Employee.

        Let's write the code for AddOrEdit action into EmployeeController
        

        Now let's add the view page for AddOrEdit action under the Views/Employee folder

        

        We have written the code to create and edit an employee, added the view page also.

        Now let's build our solution and run the application.

        Let's create 3-4 employees by entering the required fields as below

        Let's write some action methods to Index, Details, and Delete an employee as well

        Below are the screenshots for Index, Details, and Delete action methods

        https://localhost:5001/Employee/Index

        https://localhost:5001/Employee/Details/1

        Now let's delete the Harshit Kumar record... it will show an alert popup message as below

        Harshit Kumar record has been deleted from the database as we can see the below

    

        

           Below is the Employee table screenshot

        I hope it will help you :)

        

        Please comment if you face any issue regarding the same...

        You can download the source code from GitHub by click on the below link

         Click to download the Source Code

Below is the video of my running application: