Thread: BUG #17204: Import PostgreSQL view to ADO.NET Entity Framework Model

BUG #17204: Import PostgreSQL view to ADO.NET Entity Framework Model

From
PG Bug reporting form
Date:
The following bug has been logged on the website:

Bug reference:      17204
Logged by:          ilker
Email address:      ilker.sapan@gmail.com
PostgreSQL version: 13.0
Operating system:   Windows Server 2019 Datacenter
Description:

I have problem on importing PostgreSQL view to ADO.NET Entity Framework
Model .edmx

I'm using Entity Framework 6.Npgsql 6.4.3, Npgsql 5.0.10 and PostgreSQL 13.0
versions.

I generated a Database and now I need to import a View inside my .edmx
designer, but the problem is that I get an exception. Because EF wasn't able
to import the view because there is no explicit key inside of it. I've tried
to add a Key column inside the view as someone else told me to do, but I got
still the error (need private key) and I did not found a solution to my
problem yet. Is there something I can do to import my view? Thanks.