EF core 2.0 scaffolding with existing database

Question

User-154169686 posted

HI

I have a project in which I would like to use EF core 2.0 scaffolding with existing database.

I understand with reverse engineering I can create model classes base on exiting database table. Any time change in model class. I can run migration to sync database.

but not sure how I can deal with store procedure and views.

cmatskas.com/ef-core-migrations-with-existing-database-schema-and-data

Answer 1

User1120430333 posted

You could try the MSDN EF forum and see what the experts there that frequent the forum have to say.

https://social.msdn.microsoft.com/Forums/en-US/home?forum=adodotnetentityframework

Answer 2

User475983607 posted

HI

I have a project in which I would like to use EF core 2.0 scaffolding with existing database.

I understand with reverse engineering I can create model classes base on exiting database table. Any time change in model class. I can run migration to sync database.

but not sure how I can deal with store procedure and views.

cmatskas.com/ef-core-migrations-with-existing-database-schema-and-data

The EF Core reference docs cover how to execute raw queries.

https://docs.microsoft.com/en-us/ef/core/querying/raw-sql

Please read the docs.