.NET Core

• Also see C#

• Also see Visual Studio .NET

• .NET Core and .NET Standard: What Is the Difference?

• .NET Standard versions

• Compatibility of dynamically loaded assemblies

• Demystifying .NET Core and .NET Standard

From .NET Core and .NET Standard: What Is the Difference?:

.NET Standard is an API specification that defines, for a given version, what Base Class Libraries must be implemented.

.NET Core is a managed framework that is optimized for building console, cloud, ASP.NET Core, and UWP applications. It provides an implementation of .NET Standard for the Base Class Libraries.

Getting Started (09/02/2021)

Download and install .NET 5.0 (Current) from https://dotnet.microsoft.com/download (.NET 5 also supports some major sub-framework for desktop development like Entity Framework, GDI+, LINQ, and ADO.Net)

Application

Create a new console application:

dotnet new console -o TestEntityFramework
cd TestEntityFramework

Install EntityFramework:

dotnet tool install --global dotnet-ef
dotnet add package Microsoft.EntityFrameworkCore.Design
# check
dotnet ef

Database - Reverse Engineering

Reverse engineering is the process of scaffolding entity type classes and a DbContext class based on a database schema.

From MySQL, Scaffolding an Existing Database in EF Core:

dotnet add package MySql.EntityFrameworkCore --version 5.0.0-m8.0.23
dotnet ef dbcontext scaffold "server=127.0.0.1;uid=root;database=FMS" MySql.EntityFrameworkCore -o sakila -f

Check the (e.g. sakila) folder which contains all the tables mapped to entities and the Context.cs file