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

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: ilker(dot)sapan(at)gmail(dot)com
Subject: BUG #17204: Import PostgreSQL view to ADO.NET Entity Framework Model
Date: 2021-09-29 13:42:02
Message-ID: 17204-b50062269afe347b@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 17204
Logged by: ilker
Email address: ilker(dot)sapan(at)gmail(dot)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.

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2021-09-30 07:19:53 BUG #17205: pg_class.reltuples vakue wrong for brin indexes after vacuum (by many orders of magnitude)
Previous Message Tom Lane 2021-09-29 13:36:01 Re: BUG #17203: missing websearch_to_tsquery