(This solution is for EF 6. I have not tried in other EF versions. It works nice.)
Go to Model browser.
MyStoreProc is the name of the stored procedure (as an example). MyStoreProc will appear in 3 places.
- 1st place- Under Complex Types-> as MyStoreProc_result
- 2nd Place- Under Function Imports -> as MyStoreProc
- 3rd Place – Under Stored
Procdures/ 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.
Solved without any hassle 🙂