Entity Framework - relating subclass foreign key to parent class primary key

Question

I want to map the foreign key FormId of class Question from the list Subquestions to the primary key of class Form. Entity Framework is not making this relationship in the sub questions.

My Form class.

public class Form
{
    private readonly ICollection _questions = new List();

    public int Id { get; private set; }
    public string Title { get; private set; }
    public string Description { get; private set; }

    ...
}

My Question class.

public class Question 
{
    private readonly ICollection _subquestions = new List();

    public int Id { get; private set; }
    public string Title { get; private set; }
    public bool Required { get; private set; }
    
    public int? QuestionParentId { get; private set; }
    public Question QuestionParent { get; private set; }

    public int FormId { get; private set; }
    public Form Form { get; private set; }

    ...
}

What should the configuration in IEntityTypeConfiguration look like?

That should be like: Form 1 - n Question and Question 1 - n SubQuestion separately — Bin Rohan
– Bin Rohan, Commented Jun 3, 2022 at 12:50

Bin Rohan · Accepted Answer · 2022-06-03 12:47:53Z

0

Entity Configuration should be look like this

modelBuilder.Entity<Question>()
            .HasOne(q => q.Form)
            .WithMany(f => f._questions);

modelBuilder.Entity<SubQuestion>()
            .HasOne(s => s.Question)
            .WithMany(q => q._subquestions);

answered Jun 3, 2022 at 12:47

Bin Rohan

3544 silver badges13 bronze badges

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

Collectives™ on Stack Overflow

Entity Framework - relating subclass foreign key to parent class primary key

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