EF6 CodeFirst - Introducing FOREIGN KEY constraint may cause cycles or multiple cascade paths
<p>I'm trying to update-database and got this error. I've been wrestling with this for a while and can't quite figure out what's happening.</p>

<blockquote>
  <p>Introducing FOREIGN KEY constraint 'FK_dbo.Comments_dbo.Users_UserId' on table 'Comments' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.
  Could not create constraint or index. See previous errors.</p>
</blockquote>

<p>Here is my <strong>User</strong> class:</p>

<pre><code>public class User
{
    [Key, DatabaseGenerated(DatabaseGeneratedOption.Identity)]
    public int Id { get; set; }
    [Required]
    public string Name { get; set; }
    [Required]
    public string Email { get; set; }
    [Required]
    public UserType ProfileType { get; set; }
    [Required]
    public string PasswordHash { get; set; }
    [Required]
    public int Location { get; set; }
    public int? SessionTokenId { get; set; }

    public SessionToken SessionToken { get; set; }
    public List&lt;Comment&gt; Comments { get; set; }
}
</code></pre>

<p>And here is my <strong>Comment</strong> class:</p>

<pre><code>public class Comment
{
    [Key, DatabaseGenerated(DatabaseGeneratedOption.Identity)]
    public int Id { get; set; }
    [Required]
    public int UserId { get; set; }
    [Required]
    public int ArticleId { get; set; }
    [Required]
    public string Message { get; set; }
    [Required]
    public DateTime PostDate { get; set; }

    public User User { get; set; }
    public Article Article { get; set; }
}
</code></pre>

<p>I've tried to add some:</p>

<pre><code>modelBuilder.Entity&lt;Comment&gt;()
            .HasRequired(u =&gt; u.User)
            .WithMany()
            .WillCascadeOnDelete(false);
</code></pre>

<p>I think it's wrong, and I need to delete all user comments on user deleting.</p>

<p>But it gives no result. What I'm wrote wrong?</p>