Arthur Vickers

@chrsas Thanks for the additional information. So, if I can clarify, the database has no foreign key constraints, but when this was scaffolded into an EF Core model there still...

@chrsas For navigation properties to work EF needs there to be FKs in the model. This is because the relationship is represented by the FK, with the navigations acting as...

See also dotnet/efcore#2725, but leaving this as a separate issue since FKs may require a different mechanism.

@zejji I'm curious; if you have a legacy database without FK constraints, but you're using migrations to evolve the schema, then why not add FK constraints as you update the...

@zejji So what kinds of changes are you making to the database?

@zejji Thanks, understood.

@dahovey Sounds like you will need dotnet/efcore#13146, since key value zero violates the normal constraint. Both these issues are in the Backlog milestone. This means that it is not planned...

As the name indicates, query filters are for filtering queries. It would be technically very difficult to keep the context in sync due to the semantic differences between store queries...

Update https://aka.ms/efcore-docs-temporal when this is published.

Note from triage: we should re-discuss when to use EF Core and when just EF.