Enitity Framework类型中的每个属性名称都必须是唯一的 [英] Enitity Framework Each property name in a type must be unique

问题描述

我定义了以下实体以及关系映射.但是，在保存时，在 EF 6

I have the following entities defined and the relationship mapping also. However, while saving i get the error Name: Each property name in a type must be unique. Property name 'ResponseId' is already defined. in EF 6

System.Data.Entity.ModelConfiguration.ModelValidationException

这让我震惊了2天，不确定我班上的问题是什么.如果我删除ResponseOffer中的ResponseId，它工作正常.但是，我需要设置此值以将其保存在数据库及其FK中.

I am struck with this for 2 days and not sure, what is the issue in my class. If I remove, ResponseId in ResponseOffer, it is working fine. However, I need to set this value to save it in the database and its FK

请求可能包含许多响应，每个响应可能包含许多响应要约.

Request may contain many responses and each response may contain many response offer.

[Table("Response")]
public class Response : AggregateRoot // AggregateRoot is an Entity
{
    public Response(Request Request): this()
    {
        ResponseId = Guid.NewGuid();
        Request = Request;
        MaterialId = Request.MaterialId;           
    }

    public Response()
    {
    }

    public Response(Guid ResponseId)
    {
        ResponseId = ResponseId;
    }

    public Response(Guid ResponseId, Request Request)
    {
        ResponseId = ResponseId;
        Request = Request;            
    }

    public Guid ResponseId { get; private set; }     
    public virtual Request Request { get; set; }
    public bool IsActiveVersion { get; set; }
    public EntityHashSet<ResponseOffer> EditableResponseOffers => (EntityHashSet<ResponseOffer>)ResponseOffers;

}

然后

[Table("ResponseOffer")]
public class ResponseOffer : Entity
{
    public ResponseOffer()
    {
    }
    public ResponseOffer(Response response)
    {
        ResponseOfferId = Guid.NewGuid();
        Response = response;            
    }

    public Guid ResponseOfferId { get; set; }
    public string RequestItemId { get; set; }
    public Guid ResponseId { get; set; }
    public decimal Price { get; set; }
    public decimal Quantity { get; set; }      
    public string Comment { get; set; }
    public virtual Response Response { get; set; }
}

映射

    modelBuilder.Entity<Response>()
            .HasRequired(e => e.Request)
            .WithMany(e => e.Responses)
            .WillCascadeOnDelete(false);         

        modelBuilder.Entity<Response>()
            .HasMany(e => e.ResponseOffers)
            .WithRequired(e => e.Response)
            .WillCascadeOnDelete(false);

更新:

我删除了以下属性，但现在我没有得到相同的错误.但是，EF在插入时会添加额外的列 Response_ResponseId1

I have removed the following properties and now I dont get the same error. However EF adds extra column Response_ResponseId1 while insert

INSERT [dbo].[ResponseOffer]([ResponseOfferId],  [RequestItemId], 
[Price], [Quantity], [Comment], [ResponseId], [Response_ResponseId1])

推荐答案

我不确定，但是，我会尝试通过虚拟设置"EditableResponseOffers"属性 并通过删除私有的ResponseId来测试行为.

I'm not sure, but, I would try to set with virtual the "EditableResponseOffers" property and test the behavior with removing the private to ResponseId.

public Guid ResponseId { get; set; }
public virtual EntityHashSet<ResponseOffer> EditableResponseOffers => (EntityHashSet<ResponseOffer>)ResponseOffers;

这篇关于Enitity Framework类型中的每个属性名称都必须是唯一的的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！