.net - EdmAssociationConstraint : : The number of properties in the Dependent and Principal Roles in a relationship constraint

我有EdmAssociationConstraint::关系中从属角色和主要角色中的属性数量限制了EF 5中的此异常

我想使用数据注释来解决此问题

public class Task
{
    [Key, Column(Order = 0)]
    [DatabaseGeneratedAttribute(DatabaseGeneratedOption.Identity)]
    public int TaskId { get; set;}
    public string Name { get; set; }
}

public class Trigger
{
    [Key, Column(Order = 0)]
    [DatabaseGeneratedAttribute(DatabaseGeneratedOption.Identity)]
    public int TriggerId { get; set; }
    public string Name { get; set; }

    [Key, Column(Order = 1)]
    public int TaskId { get; set; }

    [ForeignKey("TaskId")]
    public virtual Task Tasks { get; set; }
}

public class TriggerHistory
{
    [Key, Column(Order = 0)]
    [DatabaseGeneratedAttribute(DatabaseGeneratedOption.Identity)]
    public int TriggerHistoryId { get; set; }

    [Key, Column(Order = 1)]
    public int TaskId { get; set; }

    [ForeignKey("TaskId")]
    public virtual Task Task { get; set; }

    [Key, Column(Order = 2)]
    public int TriggerId { get; set; }

    [ForeignKey("TaskId")]
    public virtual Trigger Triggers { get; set; }

    public string Name { get; set; }
}

最佳答案

您的Trigger类具有合成键(TriggerId，TaskId)。
但是您的TriggerHistory具有触发器导航属性，仅使用TaskId属性定义了ForeignKey。

尝试像这样在Triggers属性上更改ForeignKey:

[ForeignKey("TriggerId,TaskId")]
public virtual Trigger Triggers { get; set; }

也许将Triggers属性命名为“Trigger”，因为这不是Trigger对象的集合。

关于.net - EdmAssociationConstraint : : The number of properties in the Dependent and Principal Roles in a relationship constraint，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/17369941/