How to update DB context class in .Net Core using database first approach?

Question

I have an application in ASP web forms. I working on migrating this web form application to .net core 3.0. I am using database first approach as I have perfect tables structure, many store procedures and too much data. Today I add some new columns in data table 'Stock'. Columns name are:

Color_ID. 2. Location_Id

I also add one new table 'Locations' in my database. Now the question is how can I update the DB context model class in my project for this two tables changes using database first approach in .net core.

Saeed Gholamzadeh · Accepted Answer · 2020-09-20 19:41:42Z

5

Scaffold Context

Using the Package Manager Console

Scaffold-DbContext "your_connection_string" Microsoft.EntityFrameworkCore.SqlServer -OutputDir Models -Force

using CLI

dotnet ef dbcontext scaffold "your_connection_string" Microsoft.EntityFrameworkCore.SqlServer -o Models -f

Updating the Context

if you want to re-scaffold the model after making schema changes, you can do so by specifying the -force option e.g.:

dotnet ef dbcontext scaffold "your_connection_string" Microsoft.EntityFrameworkCore.SqlServer -force

All of the class files will be overwritten, which means that any amendments that you might have made to them e.g. adding attributes or additional members, will be lost.

edited Sep 20, 2020 at 19:41

answered Sep 20, 2020 at 19:28

Saeed Gholamzadeh

8421 gold badge8 silver badges24 bronze badges

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

2 Comments

Noor Uddin Over a year ago

Saeed Gholamzadeh Sir, Will this commands also import my sql store procedures in the model context class. I mean only tables models will update or store procedures also?

Saeed Gholamzadeh Over a year ago

in aspnetcore you can't scaffold context with db first store procedures instead, you can use context to call procedure like this approach: entityframeworktutorial.net/efcore/…

Collectives™ on Stack Overflow

How to update DB context class in .Net Core using database first approach?

1 Answer 1

Scaffold Context

Updating the Context

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Scaffold Context

Updating the Context

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related