Stored Procedure not updating in edmx

Question

Stored Procedure not updating in edmx

Mohit Sharma 5

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

AgaveJoe 30,126 Reputation points

2024-06-06T11:47:44.04+00:00

What does "not functioning as expected" mean? What steps are you performing to reproduce this problem? Can you share any source code so the community can verify your findings?

What version of Visual Studio 2022? 17.10.1?

If you feel this a problem with Visual Studio then click the "Send Feedback" button in the upper right corner of Visual Studio.
Anonymous

2024-06-21T06:56:07.4033333+00:00

Hi,@Mohit Sharma. Welcome to Microsoft Q&A.

Did AgaveJoe's answer solve your problem? If not, could you describe in more detail how you updated the edmx file, added the SP, and what your expectations were?

This official document (Designer CUD Stored Procedures - EF6 | Microsoft Learn) may be helpful to you. You can refer to it.

4 answers

Your answer

AgaveJoe 30,126 Reputation points

2024-06-06T11:47:44.04+00:00

What does "not functioning as expected" mean? What steps are you performing to reproduce this problem? Can you share any source code so the community can verify your findings?

What version of Visual Studio 2022? 17.10.1?

If you feel this a problem with Visual Studio then click the "Send Feedback" button in the upper right corner of Visual Studio.
Anonymous

2024-06-21T06:56:07.4033333+00:00

Hi,@Mohit Sharma. Welcome to Microsoft Q&A.

Did AgaveJoe's answer solve your problem? If not, could you describe in more detail how you updated the edmx file, added the SP, and what your expectations were?

This official document (Designer CUD Stored Procedures - EF6 | Microsoft Learn) may be helpful to you. You can refer to it.

Answer 1

Mohit Sharma 5

I just updating the edmx and add SP in it.

Answer 2

AgaveJoe 30,126

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.

Tim B 0 Reputation points

2024-08-12T16:18:59.6733333+00:00
I believe that the original poster specified a title that's quite clear: "When a Stored Procedure is already part of the EDMX model, AND we change the stored procedure's output columns in the Microsoft SQL database, the Update from Database does literally nothing to the complex type associated with the existing stored procedure". I have just updated Visual Studio 2022 and this is absolutely happening to me. The only (annoying) way to update the stored procedure in EDMX to match the database updates, is to delete all the traces of the existing stored procedure in EDMX:

Procedure,

Complex Type,

Function Imports

.. and, once deleted, re-add the stored procedure via Update from Database.

I believe this bug was in Visual Studio since EDMX inception, and is a known issue, but I happen to forget about it every 6 months or so.
Tim B 0 Reputation points

2024-08-12T16:24:23.39+00:00
.. and since Microsoft is probably interested in servicing the part of the population using Safari on (Intel) Macs, I would report that this site fails miserably when trying to add comments in Safari. When clicking on "Add Comments" for this thread the text below is displayed

"Use comments to ask for clarification, additional information, or improvements to the question." with No textarea, When you then click Add Comment button you get a red text below:

"Please fix the following issues to continue: Comment must be at least 5 characters."

Pretty silly if you ask me.

Answer 3

Stéphane Caron 0

After updating to Visual Studio 2022 17.8.0 we cannot import stored procedures as we used to. The workaround is to use VS 2019 or an lode VS 2022 v17.7.6 wich works fine. I've asked this question in the developer community https://developercommunity.visualstudio.com/t/1781-EDMX-does-not-import-stored-proce/10524762#T-ND10533986 and it's been under investigation since november 2023.

O. Lohkamp 76 Reputation points

2024-11-20T06:27:06.3966667+00:00

I had the same problem, had to go back to an old development VM to success (just for testing).
The solution was to delete my "...Entites" connection string in the App.config (or Web.config), then use "update from database" and simply recreate it. I have it now also again in my Server Explorer on the left side.
Till this fix (recreation) I could update and add tables, but not new stored procedure. Weird! Now it's working again!
Even uninstalling the Oracle Developer Tools extension did not help, was not the reason.
Selvakumar Sellapan 0 Reputation points

2024-11-27T02:18:01.4933333+00:00

Hi,
Please add TrustServerCertificate=True in your connection strings in the __web.config

Answer 4

Selvakumar Sellapan 0

Hi,

My dev environment is asp.net mvc 5 web app and entity framework DB first approach.
while importing stored procedure with complex type, I have faced the same issue.

Like @Stéphane Caron suggested, we used older versions of VS 2022 to resolve this issue.

Later by adding TrustServerCertificate=True in the connection strings in the __web.config, we resolved this issue.

__
https://stackoverflow.com/questions/77569893/unable-to-add-stored-procedures-to-edmx-file-in-vs-2022

Share via

Stored Procedure not updating in edmx

4 answers

Your answer