Entity Framework One-Many Relationship on Same Entity

Question

I need to define Organizational chart schema in Entity Framework.

PersonelJob Entity model is:

public class PersonelJob : BaseEntity
{
    public Int64 ID { get; set; }
    public string Name { get; set; }
    public Int64? ParentId { get; set; }
    public virtual PersonelJob Parent { get; set; }
    public virtual ICollection<PersonelJob> Childs { get; set; }
}

As you can see each job could be a job parent and have some job children.

How could map this entity to Database, with Fulent Api?

ocuenca · Accepted Answer · 2015-05-24 04:52:18Z

1

Override the OnModelCreating method on your context and add this configuration:

modelBuilder.Entity<PersonelJob>()
            .HasOptional(pj => pj.Parent)
            .WithMany(pj=>pj.Childs)
            .HasForeignKey(pj => pj.ParentId);

answered May 24, 2015 at 4:52

ocuenca

39.5k12 gold badges95 silver badges107 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Entity Framework One-Many Relationship on Same Entity

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related