EF model doesn't update correctly

Question

I've added a new table to my database then why I tried to update my EF entity model it showed that table as a new table in the list but and I select it but it wasn't being added yet

I checked the relations and keys I deleted the entity and re-created it again

here's my uml in database

and this is how the EF generates it, it misses the TeachersCourses table

You will need to supply code that you are running. It could be any number of reasons if you're new to EF. — Steve Py, Apr 27 '19 at 05:06
Does the table have a primary key? EF wont add it unless it does — Ric, May 01 '19 at 08:14

score 0 · Answer 1 · answered May 01 '19 at 08:27

0

It didn't miss the TeachersCourses table :-). It correctly created a navigation property on Teacher, called Courses. That's how a many to many foreign key relationship is represented in EF when your db schema is well done. Many teachers to many courses.

My only comment is to correct the spelling of the Course entity

answered May 01 '19 at 08:27

reckface

5,678
4
36
62

this is how the EF named it I don't know how it named the singular of Courses as Cours – Mahmoud Zakal May 01 '19 at 08:37
and how can I insert data in TeachersCourses table in this case – Mahmoud Zakal May 01 '19 at 08:39
You do, `teacher.Courses.Add(course)` or `course.Teachers.Add(teacher)` – reckface May 01 '19 at 08:58
@MahmoudZakal you can fix the naming since sometimes the ef pluralizer gets singular or plural names wrong. – reckface May 01 '19 at 09:00

EF model doesn't update correctly

1 Answers1