ForeignKey error in Entity Framework

Question

I am planning a simple two table structure:

1) Teacher Table :

public class TeacherAccount
{
    [DataType(DataType.Text), Required()]
    public string Name { get; set; }

    [DataType(DataType.Text), Required()]
    public string Address { get; set; }

    [DataType(DataType.EmailAddress), Required(), Key]
    public string Email { get; set; }

    [DataType(DataType.Password), Required()]
    public string Password { get; set; }

    [DataType(DataType.Password), Compare("Password"), Required(), NotMapped]
    public string ConfirmPassword { get; set; }

    public bool Activated { get; set; }

}

2) Subjects taught by a teacher :

public class Teacher_Subject_Map
{
    [ForeignKey("TeacherAccount")]
    public string Email { get; set; }
    public string Subjects;
}

My Concept is : For email identifying a teacher, there can be multiple subjects, which is taught by that teacher.

How ever I am getting this :

The ForeignKeyAttribute on property 'Email' on type 'xpertsdesk.Models.Teacher_Subject_Map' is not valid. The navigation property 'TeacherAccount' was not found on the dependent type 'xpertsdesk.Models.Teacher_Subject_Map'. The Name value should be a valid navigation property name.

as error in mvc5.

What I am trying to do :

Create table Teacher(Email varchar(30) Primary Key, Other Details);
Create table Subjects(Email varchar(30) References Teacher(Email), Subject varchar(30));

What am I doing wrong ?

Gabor · Accepted Answer · 2016-05-08 18:05:37Z

2

If a subject can be taught by only one teacher (one-to-many relationship):
In this case there will not be a mapping table.

public class Subject
{
    [Key]
    public string Name { get; set; }

    // This will hold the Key of Teacher
    public string TeacherEmail { get; set; }

    [ForeignKey("TeacherEmail")]
    public virtual Teacher Teacher { get; set; }
}

public class Teacher
{
    /* the original properties comes here, e.g. Email */
    public string Email { get; set; }

    // Navigation property for taught subjects
    public virtual ICollection<Subject> Subjects { get; set; }
}

If a subject can be taught by more teachers (many-to-many relationship):
The Subject class would be like this.

public class Subject
{
    [Key]
    public string Name { get; set; }

    /* other properties if needed */

    public virtual ICollection<Teacher> Teachers { get; set; }
}

And then you can configure the many-to-many relationship in your own DbContext class:

protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
    modelBuilder
        .Entity<Teacher>()
        .HasMany(teacher => teacher.Subjects)
        .WithMany(subject => subject.Teachers)
        .Map(c =>
        {
            c.ToTable("Teacher_Subject_Map");
            c.MapLeftKey("TeacherEmail");
            c.MapRightKey("SubjectName");
        });
}

edited May 8, 2016 at 18:05

answered May 8, 2016 at 18:00

Gabor

3,3162 gold badges16 silver badges23 bronze badges

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

3 Comments

Priyabrata Over a year ago

Going by your first approach, I am getting, "The foreign key name 'TeacherAccount' was not found on the dependent type 'Teacher_Subject_Map'. The Name value should be a comma separated list of foreign key property names."

Priyabrata Over a year ago

I've fixed the above error and I am back to "EntityType 'Subject' has no key defined"

Priyabrata Over a year ago

Fixed it! I didn't make the key a property.!

Collectives™ on Stack Overflow

ForeignKey error in Entity Framework

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related