Stored procedure not getting updated in EDMX

If you are facing an issue with updating the edmx file with an existing Stored Procedure. Here is what you need to do:

Lets say the name of the stored procedure is MyStoredProc.

  1. Double click on the edmx file and right click inside the diagram and select ‘Model Browser‘.
  2. Navigate to the following locations and delete the MyStoredProc instances.
    • Model > Complex Types
    • Model > Function Imports
    • Model.Store > Stored Procedures / Functions
  3. Click the Save icon or Ctrl+S and save the edmx file.
  4. Now go ahead select ‘Model from Database’ and add the stored procedure again and the updated procedure  should be available.

Reference: http://stackoverflow.com/questions/18038405/stored-procedures-and-updating-edmx

About Muhammedh Naufer

Software engineer with a passion for sports and photography. http://sharepoint.stackexchange.com/users/3759/muhammedh
This entry was posted in Development, Entity Framework, Visual Studio 2012 and tagged , , , . Bookmark the permalink.

Leave a comment