c＃ef代码第一个外键没有工作

Question

我的实体框架代码 - 第一个方法创建了以下两个表，该表应连接我的A导航属性：

-- TABLE CustomColumnData
CREATE TABLE [dbo].[CustomColumnData]
(
    [ObjID] [char](42) NOT NULL,
    [CustomColumnID] [tinyint] NOT NULL,
    [Value] [nvarchar](max) NOT NULL,

    CONSTRAINT [PK_CustomColumnData] 
        PRIMARY KEY CLUSTERED ([ObjID] ASC, [CustomColumnID] ASC)
                WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, 
                      IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, 
                      ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

-- TABLE PickLineMapper
CREATE TABLE [dbo].[PickLineMapper]
(
    [LeadingObjID] [char](42) NOT NULL,
    [PickingListNumber] [int] NOT NULL,

    CONSTRAINT [PK_PickLineMapper] 
        PRIMARY KEY CLUSTERED ([LeadingObjID] ASC)
                WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, 
                      IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, 
                      ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

-- FOREIGN KEY
ALTER TABLE [CustomColumnData]
    ADD CONSTRAINT [FK_CustomColumnData_PickLineMapper_ObjID]
        FOREIGN KEY ([ObjID]) REFERENCES [PickLineMapper] ([LeadingObjID])
            ON DELETE CASCADE;

此代码在错误代码中失败：

错误547 |
Alter表语句与外键约束“ FK_CUSTOMCOLUMNDATA_PICKLINEMAPPER_OBJID”冲突。冲突发生在数据库“ MPA”，表“ DBO.Picklinemapper”，列'LeadingObjid'。

中。

创建外键约束的代码如下：

private void InitializeForeignKeys(ModelBuilder modelBuilder)
{
    modelBuilder.Entity<PickLineMapper>()
        .HasMany(plm => plm.CustomColumnData)
        .WithOne(ccd => ccd.PickLineMapper)
        .HasForeignKey(ccd => ccd.ObjID);
}

这是两个类之一。从那里，我希望能够从customcolumndata表访问所有元素，其中picklinemapper.leadingobjid等于code> codiccolumndata.objid，无论如何customcolumndata.customcolumnid是什么。您必须知道，customcolumndata必须具有一个复合主键，该键由objid和customcolumnid组成。

public class PickLineMapper
{
    [Key]
    [Column(Order = 1, TypeName = "char(42)")]
    public string LeadingObjID { get; set; }

    [Required]
    [Column(Order = 2)]
    public int PickingListNumber { get; set; }

    public ICollection<CustomColumnData> CustomColumnData { get; set; }

    public bool IsCommissioned => Convert.ToBoolean(
        this.CustomColumnData
            .Where(ccd => ccd.CustomColumnID == MpaContext.CustomFieldID_Commissioned)
            .SingleOrDefault());
}

如何在这两个表之间正确定义工作导航属性？