Scaffold-DbContext

Question

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?

Satya Karki · Answer

You can run command via Package manager console: Sample: Scaffold-DbContext "Server=.\SQLExpress;Database=SchoolDB;Trusted_Connection=True;" Microsoft.EntityFrameworkCore.SqlServer -OutputDir Models

Rijwan Ansari · Answer

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/

Sachin Singh · Answer

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

Salman Beg · Answer

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