物體框架代碼優先遷移忽略[Key]并強制使用復合鍵

我正在嘗試使用 Guid 主鍵創建一個物件[Key]，但物體框架不斷強制創建復合鍵。

public class Challenge
{
    [Key] 
    public Guid Id { get; set; }

    public Guid ChallengerId { get; set; }
    public Guid ChallengeeId { get; set; }

    [ForeignKey("ChallengerId")]
    public virtual Player Challenger { get; set; }

    [ForeignKey("ChallengeeId")]
    public virtual Player Challengee { get; set; }

    public DateTime Initiated { get; set; }
}

和它的遷移...

migrationBuilder.CreateTable(
                name: "Challenges",
                columns: table => new
                {
                    ChallengerId = table.Column<Guid>(type: "uniqueidentifier", nullable: false),
                    ChallengeeId = table.Column<Guid>(type: "uniqueidentifier", nullable: false),
                    Id = table.Column<Guid>(type: "uniqueidentifier", nullable: false),
                    Initiated = table.Column<DateTime>(type: "datetime2", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Challenges", x => new { x.ChallengerId, x.ChallengeeId });
                    table.ForeignKey(
                        name: "FK_Challenges_Players_ChallengeeId",
                        column: x => x.ChallengeeId,
                        principalTable: "Players",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Restrict);
                    table.ForeignKey(
                        name: "FK_Challenges_Players_ChallengerId",
                        column: x => x.ChallengerId,
                        principalTable: "Players",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Restrict);
                });

請注意，我使用相同的方法創建了 Player 類，并且物體框架尊重[Key]那里的屬性。

public class Player
{
    [Key] 
    public Guid Id { get; set; }
    public string UserId { get; set; }
    [ForeignKey("UserId")]
    public virtual IdentityUser User { get; set; }
    
    public virtual ICollection<Game> Games { get; set; }
    [InverseProperty("Challenger")]
    public virtual ICollection<Challenge> OutgoingChallenges { get; set; }
    [InverseProperty("Challengee")]
    public virtual ICollection<Challenge> IncomingChallenges { get; set; }
}

migrationBuilder.CreateTable(
                name: "Players",
                columns: table => new
                {
                    Id = table.Column<Guid>(type: "uniqueidentifier", nullable: false),
                    UserId = table.Column<string>(type: "nvarchar(450)", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Players", x => x.Id);
                    table.ForeignKey(
                        name: "FK_Players_IdentityUser_UserId",
                        column: x => x.UserId,
                        principalTable: "IdentityUser",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Cascade);
                });

即使我進入遷移和改變

table.PrimaryKey("PK_Challenges", x => new { x.ChallengerId, x.ChallengeeId });

到

table.PrimaryKey("PK_Challenges", x => x.Id);

物體框架似乎在掙扎，因為它Challenges在 SQL 資料庫中使用復合鍵創建。

我正在使用 .NET 6。

uj5u.com熱心網友回復：

您的 Player 模型中可能缺少 [Key] 屬性嗎？

public class Player
{
    //Here should be a [Key] annotation
    public Guid Id { get; set; }
    public string UserId { get; set; }
    [ForeignKey("UserId")]
    public virtual IdentityUser User { get; set; }
    
    public virtual ICollection<Game> Games { get; set; }
    [InverseProperty("Challenger")]
    public virtual ICollection<Challenge> OutgoingChallenges { get; set; }
    [InverseProperty("Challengee")]
    public virtual ICollection<Challenge> IncomingChallenges { get; set; }
}

uj5u.com熱心網友回復：

我找到了罪魁禍首：AppDbContext.cs

modelBuilder.Entity<Challenge>()
                    .HasForeignKey(c => new { c.ChallengerId, c.ChallengeeId });

標籤：C＃ 。网 实体框架 实体框架核心 实体框架迁移

上一篇：ASP.NETCoreMVC：在發布Edit方法之前洗掉多對多條目

下一篇：在EFCore6中使用Many2Many的正確方法？