How should relationships and navigation properties be designed for production in Entity Framework Core?

Configure important relationships explicitly, choose delete behavior deliberately, and test referential integrity.