Scaffold-DbContext

Kevin Burton

I have an existing database that I would like some automated way of creating Models. From https://www.entityframeworktutorial.net/efcore/create-model-for-existing-database-in-ef-core.aspx I gather that Scaffold-DbContext will do this. But when I go to run it the command is not found. What do I need to do to my PowerShell environment to make this command available? Or is there a better way?

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Satya Karki5y ago
You can run command via Package manager console:
Sample:
Scaffold-DbContext "Server=.\SQLExpress;Database=SchoolDB;Trusted_Connection=True;" Microsoft.EntityFrameworkCore.SqlServer -OutputDir Models
Rijwan Ansari5y ago
In your case, code first from database (Genereate model from database for code first) will be best one. You can generate scaffold context and models from visual studio itself.

However, Scaffold-DbContext is also useful, check below link
https://www.thecodebuzz.com/efcore-scaffold-dbcontext-commands-orm-net-core/
Salman Beg5y ago
Scaffold-DbContext is available in package manager console. So you can use package manager console to run this and which will generate models for you. For PowerShell you can refer this below link, https://stackoverflow.com/questions/58607253/when-executing-the-command-scaffold-dbcontext-i-get-the-error-scripthalted
Sachin Singh5y ago
There are three approaches of generating domain models using EF , in which two are heavily used those are
Database First approach and
Code First approach
first decide which approach do you want to take.
With database First (Go to Project folder-->Right click on it--->Add--->Add New Item) then from the left pane select data tab --->Ado.Net Entity Data---> Generate model from database.

with code first approach do the same but select Genereate model from database for code first , this is called reverse engineering .

please go through all article of https://www.sharpencode.com/article/EntityFramework