Entity Framework problem showing as "Conflicting changes to the role 'ChangeOrder_Job_Target' of the relationship 'YYY' have been detected."

<p><strong>Q: What was the request about? </strong></p><p><strong>An exception (below) kept being thrown when an update to one specific field was made. &nbsp;</strong></p><pre><span style="color:rgb(163, 21, 21); font-size:13px">Conflicting changes to the role 'XXX' of the relationship 'YYY' have been detected.</span></pre><p><br><strong>Q: How did you help with the request?</strong></p><p>After *much* troubleshooting and research we came to learn that EF does not take well to circular references between database tables. &nbsp;<br><br><strong>Q: Any best practices &amp; key learnings you can share?</strong></p><p><strong>When using EF, be sure to use good judgement on how to normalize your table structures.</strong></p>