Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
375 views
in Technique[技术] by (71.8m points)

.net - Dotnet ef core relations

How can we have a one-to-many relationship when the primary key of all the models named Id?

Example:

public class Organization {
    public long Id { get; set; }
    public List<Teacher> Teachers { get; set; }
}

public class Teacher {
    public long Id { get; set; }
    public long ??? { get; set; } // what do we call OrganizationId?
    public Organization Organization { get; set; }
}

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Reply

0 votes
by (71.8m points)

The name of the variable with ??? should be called OrganizationId. I would create a separate class with the configuration for the model Teacher.

For example:

class TeacherConfiguration : IEntityTypeConfiguration<Teacher>
{
    public void Configure(EntityTypeBuilder<BoardCard> builder)
    {
        builder.HasKey(bc => bc.Id);
        builder.HasOne(bc => bc.Organization).WithMany(c => c.Teachers).HasForeignKey(bc => bc.OrganizationId).OnDelete(DeleteBehavior.Cascade).IsRequired();
    }
}

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
OGeek|极客中国-欢迎来到极客的世界,一个免费开放的程序员编程交流平台!开放,进步,分享!让技术改变生活,让极客改变未来! Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...