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.
- Double click on the edmx file and right click inside the diagram and select ‘Model Browser‘.
- Navigate to the following locations and delete the MyStoredProc instances.
- Model > Complex Types
- Model > Function Imports
- Model.Store > Stored Procedures / Functions
- Click the Save icon or Ctrl+S and save the edmx file.
- 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