EF代码首先，表关系问题

Question

我在评论中遇到了一个错误在关系中，我正在等待一个实用的答案，似乎没有困难。我在文章模型中轻松使用图片模型。我想到了在 auhor 模型中使用此表，但是我陷入了关系，该怎么办？

public class Article
{
    public int Id { get; set; }
    public string Title { get; set; } = string.Empty;
    public string Detail { get; set; } = string.Empty;
    public DateTime CreatedAt { get; set; }
    public DateTime? UpdatedAt { get; set; }
    public bool IsActive { get; set; } = false;

    // Scaler properties
    public int AuthorId { get; set; }
    public int CategoryId { get; set; }

    // Navigation properties
    public virtual Picture Picture { get; set; } = new Picture();
    public virtual Author Author { get; set; } = new Author();
    public virtual Category Category { get; set; } = new Category();
    public virtual ICollection<Comment>? Comments { get; set; }
}

public class Author
{
    public int Id { get; set; }
    public string Name { get; set; } = string.Empty;
    public string Surname { get; set; } = string.Empty;
    public string EMail { get; set; } = string.Empty;
    public string Password { get; set; } = string.Empty;
    public DateTime DateOfBirth { get; set; }
    public DateTime CreatedAt { get; set; }

    // Navigation properties
    public virtual ICollection<Article>? Articles { get; set; }
    public virtual ICollection<Comment>? Comments { get; set; }
}

public class Category
{
    public int Id { get; set; }
    public string Name { get; set; } = string.Empty;
    public byte SortBy { get; set; }

    // Navigation property
    public virtual ICollection<Article>? Articles { get; set; }
}

public class Comment
{
    public int Id { get; set; }
    public string Content { get; set; } = string.Empty;
    public DateTime CreatedAt { get; set; }
    public bool IsActive { get; set; } = false;

    // Scaler properties
    public int ArticleId { get; set; }
    public int AuthorId { get; set; }

    // Navigation properties
    public virtual Article Article { get; set; } = new Article();
    public virtual Author Author { get; set; } = new Author();
}

public class Picture
{
    public int Id { get; set; }
    public string Src { get; set; } = string.Empty;
    public string Alt { get; set; } = string.Empty;
    public string? Title { get; set; }

    // Scaler property
    public int ArticleId { get; set; }

    // Navigation property
    public virtual Article Article { get; set; } = new Article();
}

这是错误：

引入外键约束'fk_comments_authors_authorid'on 表“评论”可能会导致周期或多个级联路径。指定 在删除无操作或更新中，无操作或修改其他外国 关键约束。无法创建约束或索引。请参阅上一个 错误

在其他关系中有任何问题吗？我们可以讨论