问题描述
我定义了以下实体以及关系映射.但是,在保存时,在 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" propertyand test the behavior with removing the private to ResponseId.
public Guid ResponseId { get; set; }
public virtual EntityHashSet<ResponseOffer> EditableResponseOffers => (EntityHashSet<ResponseOffer>)ResponseOffers;
这篇关于Enitity Framework类型中的每个属性名称都必须是唯一的的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!