Self-relationship in EF6

Question

Self-relationship in EF6

Navigation

#1 by (5 votes)

3

I need to do a self-relationship in one of the entities, how do I reference the entity itself for both child records and the parent record?

public class Comentario
{
    public int IdComentario { get; set; }
    public int? IdComentarioPai { get; set; }
    public string Texto { get; set; }
    public DateTime Data { get; set; }
    public ICollection<Comentario> Respostas { get; set; }
    public Comentario ComentarioPai { get; set; }
}

c# entity-framework code-first

asked by anonymous 10.04.2014 / 15:10

1 answer

PDF view in iframe How to pass values in an Action Link that are in HTML elements?

score 5 · Accepted Answer

Set your template class to the following:

public class Comentario
{
    [Key]
    public int ComentarioId { get; set; }
    public int? ComentarioPaiId { get; set; }

    public string Texto { get; set; }
    public DateTime Data { get; set; }

    public virtual Comentario ComentarioPai { get; set; }

    public virtual ICollection<Comentario> Respostas { get; set; }
}

In the context configuration, add also:

protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
    modelBuilder.Entity<Comentario>()
        .Property(c => c.ComentarioPaiId).IsOptional();
        .HasMany(c => c.Respostas).WithOptional(c => c.ComentarioPai).HasForeignKey(c => c.ComentarioId);
}