当我想将这个NotebookModel添加到我的DB中时，它没有获得ID（它仍然是INT 32的默认值）。
通常在SaveChangesAsync()之后，对象会自动分配一个ID，这也适用于其他模型。但不适用于这些模型，尽管它们是以相同的方式构建的。

回答几个问题：

• -是，数据库已创建

• 是，模型在DbSet中
• 是的，我已经重建了API*
  我是不是忽略了什么？

C#代码：

NotebookModel newNotebook = new NotebookModel();

_db.Notebook.Add(newNotebook);
await _db.SaveChangesAsync();

笔记本-型号：

public class NotebookModel
{
    [Key]
    public int Id { get; set; }
    public List<NoteModel> Notebook { get; set; } = new List<NoteModel>();
}

注-型号：

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

    [Required(ErrorMessage = "Name is missing!")]
    public string Name { get; set; } = default!;
    public string? Value { get; set; }

    [Required(ErrorMessage = "CreationDate is missing!")]
    public DateTime CreationDate { get; set; } = default!;

    [Required(ErrorMessage = "LastEditDate is missing!")]
    public DateTime LastEditDate { get; set; } = default!;
}

数据库上下文：

public class DataBaseContext : DbContext
{
    public DataBaseContext(DbContextOptions<DataBaseContext> options) : base(options)
        {
        }

    public DbSet<NotebookModel> Notebook { get; set; }
    public DbSet<NoteModel> Note { get; set; } 
}

错误响应：

Microsoft.EntityFrameworkCore.DbUpdateException: Could not save changes. Please configure your entity type accordingly.
 ---> MySql.Data.MySqlClient.MySqlException (0x80004005): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'DEFAULT VALUES();
SELECT `Id`
FROM `Notebook`
WHERE ROW_COUNT() = 1 AND `I...' at line 2

我的Csproj文件：

<ItemGroup>
     <PackageReference Include="Microsoft.EntityFrameworkCore" Version="7.0.4" />
     <PackageReference Include="Microsoft.EntityFrameworkCore.Design" Version="7.0.4">
     <PackageReference Include="MySql.EntityFrameworkCore" Version="7.0.0" />
     <PrivateAssets>all</PrivateAssets>
     <IncludeAssets>runtime; build; native; contentfiles; analyzers; buildtransitive</IncludeAssets>
     </PackageReference>
          <PackageReference Include="Microsoft.EntityFrameworkCore.Relational" Version="7.0.4" />
          <PackageReference Include="Microsoft.EntityFrameworkCore.Tools" Version="7.0.4">
          <PrivateAssets>all</PrivateAssets>
          <IncludeAssets>runtime; build; native; contentfiles; analyzers; buildtransitive</IncludeAssets>
     </PackageReference> 
</ItemGroup>