1 to 1, 1 to Many and Many to Many Relationships with EFCore in 2023

[@gabrielgrigore3431]

By far the best explanation, I've been looking everywhere for something this clear, thank you, subscribed

[@pg_569]

Awesome video. Please make more videos.

[@Ariyo-idowuBolaji]

He is human guys... This is the human explanation of relationships for c# dev.. straight to the 4king point.. ayy.. big ups tho

[@rafxjay]

+1 Subscriber! good stuff!

[@ImmoTheBest]

Definitely the best explanation I have found. Thank you! Looking forward to more videos on this topic.

[@steveb1307]

At last getting my head around this. Thanks!

[@zhyyv]

Thank you again! please continue with the videos please please!!

[@ediblenecklace7007]

Great video! Looking forward to the next one

[@iseesharp7475]

Thanks!

[@teto3252]

Very helpful and easy explained! Thanks!

[@piotrjakis1842]

Keep going man. Nice video, very informative.

[@iseesharp7475]

Thanks for the comment!

[@kotto4416]

Hi, just wanted to encourage you to keep making videos like that, it is a great content and I belive if you will continue on you will succeed :)

[@iseesharp7475]

Thank you for the kind words 🙂

[@محمدالحامد-ث7ص]

Thanks a lot

[@paollarce5137]

What if I need store extra information in the Image and Blog relationship table ?

[@iseesharp7475]

If you want to add new fields? Then watch this video: kzbin.info/www/bejne/d2XXoXuvlMR_hJI

[@davido459]

good video

[@tnielsen9041]

bedre end gorm

[@followerofchrist1984]

May you please show the database diagram? just to see if it shows the 1 to 1 relationship

[@iseesharp7475]

Hi! Here is a database diagram. A few extra fields on the user table but it shows the same structure imgbb.com/RQnqXY1

[@jacques-oliveira-01]

bravo!

[@xdmilos1]

👍🏻

[@nokibulislam9423]

Aren't we supposed to create a separate table for many to many relationship?

[@iseesharp7475]

Hi - In this example we have created a seperate table, the relationship is between the 'Blog' and the 'image' table. Then the 'BlogImage' table which connects the two allows any Blog to be related to multiple Images and any Image to be related to multiple blogs. If I've misunderstood your question please let me know - happy to help!

[@nokibulislam9423]

@@iseesharp7475 Oh sorry, might have missed it. Is there any way you could review my entity design? I have started learning EF and as far as I have seen. We can just do ICollection on 2 entities to have many to many relationship. But by SQL standard we must create another joining table. I don't know which one is best, or it's about use cases.

[@iseesharp7475]

The BlogImage table was created automatically by entity framework when we defined a many to many relationship between the Blog class and Image class using the navigation properties.

[@nokibulislam9423]

@@iseesharp7475 uh huh. This is what I read in EF docs, that EF automatically created joining tables. Right? I was confused because it didn't create for me. I will just have to debug my way through it I guess. Thanks for taking the time sir. You are the best, loving the community

[@iseesharp7475]

@@nokibulislam9423 Yeah as long as you have the ICollection in Blog and Image the join table should be created for you. Fell free to send me a github repo or pastbin if you need help. Thanks for the kind words!