EF Database first how to update model for database changes?
Not a fix but a workaround: Is it not an option to simply remove and regenerate the EDMX and the generated classes? That's what I do, it is much easier than working with the update feature, and the result seems to be the same. Your POCO extensions still remain the same and functional.
I use database first and I have my SQL upgrade scripts, the generated EDMX and my Generated models in source control and the changes there are very easy to manage. Here is a rough outline of my DB upgrade process for each version:
- Create .sql script for the upgrade, statements like
CREATE TABLE
etc. - Delete generated files: Model.Context.tt, Model.tt, Model.edmx
- Remove Entities string from Web.config (if you use it)
- Create the EDMX and Context files the same way you did for the first time
- If you use source control (I hope you do!) check what has changed
- Test
- Commit!
user576510
Updated on June 04, 2022Comments
-
user576510 almost 2 years
In a class library
Ado.net Entity Data Model
is has generated POCO classes. These were generated fine for the first time. But database changes are not being reflected. Inedmx
diagram right clicking and choosingUpdate Model from Database
show newly created table but it do not add table even after selecting it to add.I tried running .tt (by right click and Run custom tool) but even it did not regenerated the Poco classes as per latest DB changes.
Help please