ASP.NET MVC using Entity Framework many to many relationship

Riya Yadav

9y3.7k.NET

i have a problem with many to many relationship using entity framework

how to perform CRUD Function and not using repository pattern

for e.g. i have three table

1. Table 1 is for Posts which stores post id and other details

2. Table 2 is for tags which stores all tag id and tagname

3. Table 3 is for POSTTAG which stores PostID and TagID

i am using listbox for multiselect tags and able to insert new post with tags into database but unable to edit and delete that posts with tags

So Any Expert Can explain me CRUD Action How to perform or share your with me

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nilesh Shah9y ago
Accepted answer
This happens with EF as it cannot treat a table (Table 3 in your case) with only foreign keys in it as an entity.

Either you have to add a surrogate key (auto id) column in Table 3, or you have to manage the tags as being child of post, or posts as being child of tags
i.e. do edit and delete on Posts.tags or Tags.posts
Nilesh Shah9y ago
https://www.codeproject.com/tips/893609/crud-many-to-many-entity-framework

https://www.codeproject.com/Articles/234606/Creating-a-Many-To-Many-Mapping-Using-Code-First
Riya Yadav9y ago
hey nilesh do you write little code for edit action