Stored procedure does not show up in model after adding it via Model Update Wizard
Using .NET Framework 4.7, Entity Framework 6, Npgsql, EntityFramework6.Npgsql, Npgsql Integration extension in VS2019.
After adding a table from our Postgres database, the table shows up within the model along with all expected classes. I'm able to successfully get the data in our application.
After adding a stored procedure literally nothing happens. I flick finish and the Model does not change, the SP is not listed in Model Browser, and the Output window says this:
The model was generated with warnings or errors.OurCompanyDB.edmxPlease see the Error List for more details. These issues must be fixed before running your application.
Loading metadata from the database took 00:00:02.0935882.
Generating the model took 00:00:00.9904103.
I don't see any issues in the Error List. What am I doing wrong?
The non-core Npgsql EF 6 is no longer being actively maintained - someone from the community may be able to provide help, but I'd recommend planning a move to EF Core.