Go to Model browser. MyStoreProc is the name of the stored procedure (as an example). MyStoreProc will appear in 3 places.

  1. 1st place- Under Complex Types -> as MyStoreProc_result
  2. 2nd Place- Under Function Imports -> as MyStoreProc
  3. 3rd Place – Under Stored Procedures/Functions -> as MyStoreProc

Delete all three from model. Save the edmx (by clicking in the window then ctrl+S). Then right click and click update the model from database. Then add the updated stored procedure and Save again.

Sources:

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

Last modified: October 31, 2020

Author

Comments

Write a Reply or Comment