How to scaffold Database in ASP.NET Core using Visual Studio Code

Question

I have tried using the following command ( which works fine if I use Visual Studio) :

Scaffold-DbContext "Server=12.345.567.890;Database=ABC;Trusted_Connection=True;User Id=xyz;Password=12345;Integrated Security=false;" Microsoft.EntityFrameworkCore.SqlServer -OutputDir Models -f

While trying the above command using Visual Studio code terminal, I get this error:

The term 'Scaffold-DbContext' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again

Did you install Microsoft.EntityFrameworkCore.Tools package ? — Mohsen Esmailpour
– Mohsen Esmailpour, Commented Nov 15, 2017 at 7:01
Yes. Do I need to install something in Visual Studio Code editor? — Adrita Sharma
– Adrita Sharma, Commented Nov 15, 2017 at 8:24

Adrita Sharma · Accepted Answer · 2019-06-03 06:55:34Z

13

You may have to run the command line version of scaffolding. The command you have posted is for the Package Manager in Visual Studio

dotnet ef dbcontext scaffold "Server=12.345.567.890;Database=ABC;Trusted_Connection=True;User Id=xyz;Password=12345;Integrated Security=false;" Microsoft.EntityFrameworkCore.SqlServer -o Models

Source ASP.NET Core - Write Apps with Visual Studio Code and Entity Framework

edited Jun 3, 2019 at 6:55

Adrita Sharma

22.3k11 gold badges75 silver badges85 bronze badges

answered Dec 5, 2017 at 17:05

Tubs

73710 silver badges20 bronze badges

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

Collectives™ on Stack Overflow

How to scaffold Database in ASP.NET Core using Visual Studio Code

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related