.Net Blazor id MERGE语句与FOREIGN KEY约束冲突问题

我正在做一个项目，我关注的是一位培训师。当我进入更新过程时，我开始收到错误，当我使用断点时，我意识到在保存阶段 QuizId 值变为 0000。当我检查数据库时，我的所有连接都是正确的，id 值也可用，但我的输出有问题。

问题.cs

[Key]
public Guid Id { get; set; }
public string Text { get; set; }

public Guid QuizId { get; set; }
[ForeignKey(nameof(QuizId))]
public virtual Quiz Quiz { get; set; }

public virtual ICollection<Options> Options { get; set; } = [];

选项.cs

[Key]
public int Id { get; set; }

public string Text { get; set; }
public bool IsCorrect { get; set; }
public Guid QuestionId { get; set; }

[ForeignKey(nameof(QuestionId))]
public virtual Questions Questions { get; set; }

测验.cs

  [Key]
  public Guid Id { get; set; }
  public string? Name { get; set; }
  public int TotalQuestions { get; set; }
  public int TimeInMinutes { get; set; }
  public bool IsActive { get; set; }

  public Guid CategoryId { get; set; }
  [ForeignKey(nameof(CategoryId))]
  public virtual Category? Category { get; set; }

  public ICollection<Questions> Questions { get; set; } = [];

下面是我用来保存数据的代码块

public async Task<QuizApiResponse> SaveQuizAsync(QuizSaveDto dto)
{
    var questions = dto.Question.Select(q => new Questions
    {
        Id = Guid.NewGuid(),
        Text = q.Text,
        Options = q.Option.Select(o => new Options
        {
            Id = 0,
            Text = o.Text,
            IsCorrect = o.IsCorrect
        }).ToArray()
    }).ToArray();

    if (dto.Id == Guid.Empty)
    {

        var quiz = new Quiz
        {
            Id = Guid.NewGuid(),
            Name = dto.Name,
            CategoryId = dto.CategoryId,
            TotalQuestions = dto.TotalQuestions,
            TimeInMinutes = dto.TimeInMinutes,
            IsActive = dto.IsActive,
            Questions = questions
        };
        _context.Quizzes.Add(quiz);
    }
    else
    {
        var dbQuiz = await _context.Quizzes.FirstOrDefaultAsync(q => q.Id == dto.Id);//QuizId have
        if (dbQuiz == null)
        {
            return QuizApiResponse.Fail("Quiz doesn't exists");
        }
        dbQuiz.CategoryId = dto.CategoryId;
        dbQuiz.IsActive = dto.IsActive;
        dbQuiz.Name = dto.Name;
        dbQuiz.TimeInMinutes = dto.TimeInMinutes;
        dbQuiz.TotalQuestions = dto.TotalQuestions;
        dbQuiz.Questions = questions;//QuizId is 0000

        _context.Quizzes.Update(dbQuiz);// burada QuizId null
    }

    try
    {
        await _context.SaveChangesAsync();
        return QuizApiResponse.Success();
    }
    catch (Exception ex)
    {
        return QuizApiResponse.Fail(ex.Message);
    }
}

这是我的数据库架构的示意图

当我使用断点继续时检测到的点

我得到的错误如下

Microsoft.EntityFrameworkCore.Update[10000] 保存上下文类型“BlazingQuiz.Api.Data.Repositories.QuizContext”的更改时，数据库中发生异常。Microsoft.EntityFrameworkCore.DbUpdateException：保存实体更改时发生错误。有关详细信息，请参阅内部异常。---> Microsoft.Data.SqlClient.SqlException (0x80131904)：MERGE 语句与 FOREIGN KEY 约束“FK_Options_Questions_QuestionId”冲突。冲突发生在数据库“BlazingQuiz”、表“dbo.Questions”、列“Id”中。在 Microsoft.Data.SqlClient.SqlConnection.OnError（SqlException 异常，布尔 breakConnection，Action 1 wrapCloseInAction) at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction）在 Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning（TdsParserStateObject stateObj，布尔 callerHasConnectionLock，布尔 asyncClose）