Visual Studio 2022 Cannot Update EDMX Entity Model from Database

Question

All of a sudden I cannot update the .edmx files I have in all of my projects in Visual Studio 2022. This is something I have done tons of times on various projects for years: open the .edmx, right click empty space, "Update Model from Database".

Now it brings up a dialog for choosing my data connection (the connection strings are already in the config files and have been for years). Then the dialog just closes with no errors at all. Happens for all projects and don't know where to go from here?

Answer 1

I just experienced the same issue with Visual Studio 2022, and upon further investigation, I discovered that there are issues with VS2022 and .edmx from version 17.4 onwards.

Nevertheless, it appears that the development team behind VS2022 is already aware of this issue and is expected to release a new version that addresses it. However, I was able to "fix" it temporarily by following the workaround mentioned in the link, which involved removing “MultipleActiveResultSets=True;” from the connection string in the app.config.

Answer 2

Microsoft has fixed this issue in the 17.5.5 version. I update mine and it worked! Hope this will help.