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.

ASP.NET Core
ASP.NET Core
A set of technologies in the .NET Framework for building web applications and XML web services.
4,281 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 26,671 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