How to Configure a Self-Referencing Many-to-Many Relationship (Followers/Following) in EF Core
Model followers and following on a single User entity in EF Core 11: what the convention builds, why SQL Server quietly turns one join foreign key into ClientCascade, how to map an explicit Follow join entity with a timestamp, and how to delete a user without error 547 or 1785.