title: EF Core error update-database when dependent entity has multiple reference to parent entity
body: <p>I am new to EF Core. I have the two table which is almost similar to the following two tables as shown below:</p>
  
  <pre><code>public class Post
  {
      public int PostId { get; set; }
      public string Title { get; set; }
      public string Content { get; set; }
  
      public int AuthorId { get; set; }
      public User Author { get; set; }
  
      public int ContributorId { get; set; }
      public User Contributor { get; set; }
  }
  
  public class User
  {
      public string Id { get; set; }
      public string FirstName { get; set; }
      public string LastName { get; set; }
  
      [InverseProperty("Author")]
      public List&lt;Post&gt; AuthoredPosts { get; set; }
  
      [InverseProperty("Contributor")]
      public List&lt;Post&gt; ContributedToPosts { get; set; }
  }
  </code></pre>
  
  <p>when i run update-database command, i am getting the following error</p>
  
  <pre><code>Introducing FOREIGN KEY constraint 'FK_Post_User_AuthorId' on table 'Post' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.
  </code></pre>
  
  <p>Can anyone please help what am i doing wrong and how to solve this in the best way?</p>
  
  <p>Thanks</p>