I have a model where I get a Cannot reset a RelatedNavigationProperty once its set exception on fetching metadata.
This is being caused because my model has foreign keys that reference more than one parent entity. While this is not possible at the database level between tables, it is possible at the database level between one table, one other table and any number of views witch include the other table and its key. It is also possible in domain models and is supported by both EF 6 and EF Core.
Consider the following:
Here SubJobCrew.SubJobKey is a foreign key to both SubJob and SubJobUi. In the database SubJobUi is a view which includes the table SubJob and its key.
Anyway this could be addressed?
Thx
I have a model where I get a Cannot reset a RelatedNavigationProperty once its set exception on fetching metadata.
This is being caused because my model has foreign keys that reference more than one parent entity. While this is not possible at the database level between tables, it is possible at the database level between one table, one other table and any number of views witch include the other table and its key. It is also possible in domain models and is supported by both EF 6 and EF Core.
Consider the following:
Here SubJobCrew.SubJobKey is a foreign key to both SubJob and SubJobUi. In the database SubJobUi is a view which includes the table SubJob and its key.
Anyway this could be addressed?
Thx