EntityFramework Scaffold-DBContext not recognised

Question

I'm very new to the world of .net, looking at trying to port one of my apps to this platform so I've been working through tutorials using the Code First with entity framework connecting to a data source using CRUD operations for data.

I've now got to try and reverse engineer my existing db as I want to try the Database First Approach which will be what we end up using as it already exists. However when I use the Scaffold-DBContext command in the package manager console I get the Scaffold-DBContext is not recognized ...

After a couple of days reinstalling frameworks, updating powershell, working out where csproj files are to make sure references to the tools included the frameworks were OK, and removing nuget cache (basically any info I could find to try and get this working), I realised that if I create a new project with authentication switched off in the project, the Scaffold-DBcontext command seems to work ok. Is there a reference or package I need to install to get this working when I've selected to create a project that will have authentication?

Cheers

I have had issues running some commands in the PMC, as well. I find it often helps to cd to the directory that contains your .csproj file (or whichever Project file you have.) — Andrew S
– Andrew S, Commented Jul 28, 2017 at 17:20
It is possible issue with init.ps1 script from tools package not running correctly. Try removing & installing package again & restarting VS. Worst case run init.ps1 manually. — Smit
– Smit, Commented Jul 29, 2017 at 0:15

user2771704 · Accepted Answer · 2017-07-27 12:43:39Z

10

Strange bug indeed,I always used next approach and it worked in all cases. In order to use Scaffold-DBContext with SqlServer you should have 3 packages:

Microsoft.EntityFrameworkCore.SqlServer
Microsoft.EntityFrameworkCore.SqlServer.Design
Microsoft.EntityFrameworkCore.Tools

And then use such a line in Package Manager Console:

Scaffold-DBcontext "your connection string" Microsoft.EntityFrameworkCore.SqlServer

If this approach did not work, something seems to be broken in project so please then use -verbose flag like:

Scaffold-DBcontext "your connection string" Microsoft.EntityFrameworkCore.SqlServer -verbose

To get more information about your error. Also sometimes simple dotnet restore command in Package Manager Console helps.

edited Jul 27, 2017 at 12:43

answered Jul 27, 2017 at 12:34

user2771704

6,2526 gold badges41 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

JK36 Over a year ago

Hi, just recreated a new project with authentication turned on and it works. Really weird I've not changed anything, and they're the same package I reinstalled over and over again (I'm following a tutorial with these installed as prerequisites). Thank you for replying to my initial query

Collectives™ on Stack Overflow

EntityFramework Scaffold-DBContext not recognised

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related