Arthur Vickers
Arthur Vickers
Note from triage: this needs investigating. The left/right naming here is proving to be quite confusing.
Note for triage: updated to point to here for now: https://learn.microsoft.com/en-us/ef/core/providers/sql-server/misc#savechanges-and-database-triggers
The bottom line is that if NRTs are enabled and the foreign key is not specified, then the nullability of the navigation to the principal is used. Here's the information...
Re-opening to consider adding the table to the docs.
Note from triage: document blue/green migrations approaches.
Note from triage: document
Agreed the wording could be better here. The last table is specifically what happens when the dependents are _not loaded_. You will get an exception in this case, unless the...
@CasperWSchmidt `SetNull` would be a wonderful default--but SQL Server support for it is very limited. The point here is that you _must_ load dependents otherwise this scenario will _always_ throw.
See https://learn.microsoft.com/en-us/ef/core/logging-events-diagnostics/