I was trying to update my .edmx (ADO.NET) file to get updated or you can say newly added columns, but I wasn't able to get it, what is the proper way to update or refresh the model to get new database table columns, when the database changes.
I do not want the process of deleting the complete Models and again adding them from database.
You can refresh the EDMX model, by right-clicking on your EDMX file and selecting Open With -> ADO.NET Entity Data Model Designer
Right-click on the designer surface of the EDMX and click Update Model From Database.
All entities are refreshed by default, new entities are only added if you select them
If the above method doesn't work. (You can delete the entire model in .EDMX file and re-add all the tables/SP's from the database as stated below)
It is better to use the first approach always, since many times you are working with a team of developers, and don't know which tables/Stored procedure need to re-included.
Subscribe to our weekly Newsletter & Keep getting latest article/questions in your inbox weekly