If any changes have made on the datatype or constraints(e.g. not null - null) of a particular column in table and performing
Update model from database (Refresh a particular table) in entity framework is not updating the entity model.
Each time I have to delete and re-create the table manually.
Is this only solution? or any other best way to do this?
delete the applicable table(s) from your
model, than select
Update model from database, EF usually only checks for new fields, not changes to existing fields.
Check if the new updated/created table in the database contains an identity key column (like an ID column). Entity Framework is especially sensitive when working with tables that don't represent uniqueness in their records.