I just updating the edmx and add SP in it.
Stored Procedure not updating in edmx
Adding or updating a stored procedure in the EDMX file is currently not functioning as expected in the latest version of Visual Studio.
2 answers
Sort by: Most helpful
-
-
AgaveJoe 27,696 Reputation points
2024-06-06T13:24:52.76+00:00 I added a function to an EDMX file with issue.
You did not tell us what "not functioning as expected" means or explain the steps preformed to add or update a stored procedure. The community can only guess what's wrong or what you are doing.
I imported a new stored procedure using Visual Studio 17.10.1 with EF 6 (Database First) simply by following the official documentation.
First, I created a new procedure in SSMS using standard T-SQL CREATE PROCEDURE. Next, I right clicked an empty space in the EDMX designer and selected "Update Model from Database". I selected the stored procedure node to get the latest procedures. Next, I right clicked an empty space in the EDMX designer and selected "Import Function". I gave the import a name then selected the procedure from the list of procedures. It just worked... I can see the procedure in the model explorer and I can execute the function in code.