search

npgsql / EntityFramework6.Npgsql

Entity Framework 6 provider for PostgreSQL
PostgreSQL License
66 stars 53 forks source link

Issue with postgresql Views import in Entityframework #199

Open SaurabhDeveloper-connect opened 8 months ago

SaurabhDeveloper-connect commented 8 months ago

Issue with EntityFramework6.Npgsql for .net 4.8 framework.

I am trying to import views from postgres env, we are getting error of PrimaryKey not found in views, however primary keys are added in tables.

For the work around I added Views manually in .net edmx file- In Context file- added reference Added Entity file in *.tt Added reference of Views in edmx at different places like store, mapping and entitySet.

It is compiling and not giving any error. However when I am running the solution it is throwing error-

System.InvalidOperationException HResult=0x80131509 Message=The entity type vwuserlogin is not part of the model for the current context. Source= StackTrace:

at System.Data.Entity.Internal.InternalContext.UpdateEntitySetMappingsForType(Type entityType) at System.Data.Entity.Internal.InternalContext.GetEntitySetAndBaseTypeForType(Type entityType) at System.Data.Entity.Internal.Linq.InternalSet`1.Initialize() at System.Data.Entity.Internal.Linq.InternalSet`1.get_InternalContext() at System.Data.Entity.Internal.Linq.InternalSet`1.get_Local() 'connectData.vwuserlogins.Local' threw an exception of type 'System.InvalidOperationException' Npgsql version: -4.1.12 Entityframework.Npgsql- 6.4.3 PostgreSQL version: 14 Operating system: Windows Thanks.
roji commented 8 months ago

@SaurabhDeveloper-connect I'm really not sure we'll be able to help you here... For one thing, there's a lot of details missing from your report - always try to submit a minimal, runnable code sample so that the maintainer can reproduce your error and investigate it.

But beyond that, non-core EF6 has been archived for a long while, and I definitely don't have the knowledge to help you with it. Maybe someone in the community can.