How to connect to MySQL server using Entity Framework Core

Step by Step - Database First

First install these packages

1. Microsoft.EntityFrameworkCore.Design

So on Powershell go to project folder [right click on project and select open in terminal (visual studio)]

Now, you can run this command

dotnet ef dbcontext scaffold "Servel=localhost;Database=tempSQLonNetCore;user=root;password=;" "Pomelo.EntityFrameworkCore.MySql"

If your connection is true, your DbContext Generated and entities adding to your project.

Now you must inject DbContext, Described in the Codefirst section

Step by Step - Code First

First install these packages

1. Microsoft.EntityFrameworkCore
2. Microsoft.EntityFrameworkCore.Tools
3. Pomelo.EntityFrameworkCore.MySql

Add connection string look like in appsetting.json

"ConnectionStrings" : {
    "DefaultConnection" : "Servel=localhost;Database=tempSQLonNetCore;user=root;password=;"
}

**Now, Create your DB context **

public class ApplicationDbContext : DbContext
{
    public ApplicationDbContext(DbContextOptions<ApplicationDbContext> options) : base(options)
    {

    }

    // Your Entities
}

finally configure the app for connecting

var connectionString = builder.Configuration.GetConnectionString("DefaultConnection");
builder.Services.AddDbContext<ApplicationDbContext>(options => {
     options.UseMySql(connectionString, ServerVersion.AutoDetect(connectionString));
});

Now you can use Migration if you need to create or update your database Migration

Install "Pomelo.EntityFrameworkCore.MySql" using the NuGet Package Manager in Visual Studio 2019.

Then follow the instructions to configure it in your project: https://github.com/PomeloFoundation/Pomelo.EntityFrameworkCore.MySql/#getting-started

Disclaimer: I have made a small number of contributions to the Pomelo package.

EFCore is a package, not a file you would add to your project. Go to Project>NuGet Package Manager and install Microsoft.EntityFrameworkCore, Microsoft.EntityFrameworkCore.Tools. Then you can scaffold the connection to your database by running the scaffold-dbcontext command in the PM console.

did you try installing through the console?

Install-Package Microsoft.EntityFrameworkCore -Version 5.0.11

make sure that this source is added to your nuget sources in VS https://api.nuget.org/v3/index.json