嗨,我有一个模型类,像这样
public class Individual : EntityBase
{
public Individual()
{
RelatedIndividuals = new HashSet<RelatedIndividual>();
}
public string FirstName { get; set; }
public string PersonalNumber { get; set; }
public ICollection<RelatedIndividual> RelatedIndividuals { get; set; }
}这个人会有一些相关的人与一些relationType,我希望在同一个表中有多对多的连接,所以我创建了另一个类
public class RelatedIndividual
{
[Column("RelatedIndividualType")]
public RelatedIndividualType RelatedIndividualType { get; set; }
[Key, Column(Order = 0)]
public long IndividualId { get; set; }
[Key, Column(Order = 1)]
public long RelatedIndividualId { get; set; }
}我试着在我的contextDB中做
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
modelBuilder.Entity<Individual>()
.HasMany(p => p.RelatedIndividuals)
.WithMany()
.Map(m =>
{
m.MapLeftKey("IndividualId");
m.MapRightKey("RelatedIndividualId");
m.ToTable("RelatedIndividual");
});
}但是我在WithMany上出错了
“严重性代码说明项目文件行抑制状态错误CS1061 'CollectionNavigationBuilder‘不包含'WithMany’的定义,并且找不到接受类型为'CollectionNavigationBuilder‘的第一个参数的可访问扩展方法'WithMany’(您是否缺少using指令或程序集引用?) Repositories C:\Users\Luka\Desktop\Individuals\Repositories\Context\IndividualsDbContext.cs 23 Active”
有什么建议吗?怎样做才是正确的呢?
AFter编辑:我试过了
public class Individual : EntityBase
{
public Individual()
{
RelatedIndividuals = new HashSet<RelatedIndividual>();
RelatedIndividualsOf = new HashSet<RelatedIndividual>();
}
[MaxLength(50),MinLength(2), Column(TypeName = "nvarchar(50)")]
public string FirstName { get; set; }
[MaxLength(50), MinLength(2), Column(TypeName = "nvarchar(50)")]
public string LastName { get; set; }
public ICollection<RelatedIndividual> RelatedIndividuals { get; set; }
public ICollection<RelatedIndividual> RelatedIndividualsOf { get; set; }
}我的第二节课
public class RelatedIndividual
{
[Column("RelatedIndividualType")]
public RelatedIndividualType RelatedIndividualType { get; set; }
[DatabaseGenerated(DatabaseGeneratedOption.None)]
public long IndividualId { get; set; }
[ForeignKey("IndividualId")]
public Individual Individual { get; set; }
[DatabaseGenerated(DatabaseGeneratedOption.None)]
public long RelateIndividualId { get; set; }
[ForeignKey("RelateIndividualId")]
public Individual RelateIndividual { get; set; }
}我的上下文是这样的
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
modelBuilder.Entity<RelatedIndividual>()
.HasKey(e => new { e.IndividualId, e.RelateIndividualId });
modelBuilder.Entity<RelatedIndividual>()
.HasOne(pt => pt.Individual)
.WithMany(p => p.RelatedIndividuals)
.HasForeignKey(pt => pt.IndividualId);
modelBuilder.Entity<RelatedIndividual>()
.HasOne(pt => pt.RelateIndividual)
.WithMany(t => t.RelatedIndividualsOf)
.HasForeignKey(pt => pt.RelateIndividualId)
.OnDelete(DeleteBehavior.Restrict);
}当我创建实体人只是它的工作正常,当我创建实体人和在实体人我添加RelatedIndividual,Id不匹配,它添加了RelatedIndividuals和relatedIndividualsOf,例如,如果我新创建的个人是Id 2,我关联到Id 1当它保存在它的基础2 ,2不是1,2帮助。
发布于 2019-12-14 19:52:34
如何将此信息存储在单个数据库表中?
但是即使你可以- EF核心并不直接支持多对多关系。您需要定义连接表,以便拥有两个一对多关系。这就是数据库建模的工作方式。
EF 6确实隐式地创建了一个连接表,但幸运的是EF核心没有
https://stackoverflow.com/questions/59334145
复制相似问题