The dotnet dbcontext Scaffold ef and scaffold-dbcontext command does not find the package

Question

The dotnet dbcontext Scaffold ef and scaffold-dbcontext command does not find the package

NGOUNOU VICTOR PEREZ 1

I am trying to generate my models from the database using Entity framework via reverse engineering. but the command does not work.
Here is the exact command I entered

dotnet ef dbcontext scaffold  "Data Source=.; Initial Catalog=DiceDatatable; " Microsoft.EntyFrameworkCore.SqlServer --output-dir Models

it gives me the following error:

Unable to find provider assembly 'Microsoft.EntyFrameworkCore.SqlServer'. Ensure the name is correct and it's referenced by the project.

I don't understand what is happening because I installed everything as you can see in the image above

I specify that all the old and new project generates the same error.

the problem occurs after i updated visual studio 2022 from preview to current version.
I am also moving from sql server 2016 to sql server 2022

Environmental Information

EF Core version: 6.4
Database provider: Microsoft.EntityFrameworkCore.SqlServer
Target framework: NET 6.0
Operating system: windows 11
IDE: Visual Studio 2022 17.1.4

Karen Payne MVP 31,001 Reputation points

2022-04-16T00:57:00.193+00:00

Try using EF Power Tools, see if this tool works, it's free and reverse engineers with EF Core installed but later of course it needs to be installed.
NGOUNOU VICTOR PEREZ 1 Reputation point

2022-04-16T01:52:42.81+00:00

Thank you very much for the workaround. It works well
but I would like to know if there is a solution to solve this problem. because I find EF Core Power Tools slow to use
Karen Payne MVP 31,001 Reputation points

2022-04-16T02:28:19.577+00:00

Don't know a work-a-round, best to use the feedback/issue button in Visual Studio.

For the record, EF Power Tools even if you think it's slow provides more options with zero fuss. Been using the extension for years.

Karen Payne MVP 31,001 Reputation points

2022-04-16T00:57:00.193+00:00

Try using EF Power Tools, see if this tool works, it's free and reverse engineers with EF Core installed but later of course it needs to be installed.
NGOUNOU VICTOR PEREZ 1 Reputation point

2022-04-16T01:52:42.81+00:00

Thank you very much for the workaround. It works well
but I would like to know if there is a solution to solve this problem. because I find EF Core Power Tools slow to use
Karen Payne MVP 31,001 Reputation points

2022-04-16T02:28:19.577+00:00

Don't know a work-a-round, best to use the feedback/issue button in Visual Studio.

For the record, EF Power Tools even if you think it's slow provides more options with zero fuss. Been using the extension for years.

Answer 1

There is a typo: (Microsoft.EntyFrameworkCore.SqlServer) in your command.

It should be,

dotnet ef dbcontext scaffold "Data Source=.;Initial Catalog=DiceDatatable; " Microsoft.EntityFrameworkCore.SqlServer --output-dir Models

And note, you need to have following 2 packages installed,

Microsoft.EntityFrameworkCore.Design (I see you don't have this installed)  
Microsoft.EntityFrameworkCore.SqlServer

The dotnet dbcontext Scaffold ef and scaffold-dbcontext command does not find the package

1 answer

Activity