Stored Procedure not updating in edmx

Mohit Sharma 0 Reputation points
2024-06-06T10:57:27.7366667+00:00

Adding or updating a stored procedure in the EDMX file is currently not functioning as expected in the latest version of Visual Studio.

.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,648 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Mohit Sharma 0 Reputation points
    2024-06-06T12:35:09.6266667+00:00

    I just updating the edmx and add SP in it.

    0 comments No comments

  2. 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.

    0 comments No comments