One of the best videos explaining this! I’m using it to help build an iOS PassKit web service. The many to many requirement of the Device and Pass seem to map nicely to Author/Book. Thanks!
Hello Sir, I have followed your tutorial and configured the many to many relationship via the Model Builder. Now I have a problem, how can I perform the CRUD queries in C#? I get an error in the intellisense saying that I cannot convert from a class model to a class join model (for example, cannot convert from Movie to MovieWatchList). Do you have tutorials covering this? Please I need help.
Am I missing something? Is this how this was done before? Anyhow, nowadays just put ICollection on both classes and entity fc will handle everything else
Yes, things have changed in EF 5 (EF Core 5). To be honest, it's a total mess with different EF versions. For instance on EF for .NET Framework many-to-many relationships are configured by convention (as you said) for quite a few years. However, in EF Core this was never possible and you would need an object for the joining table and configure the relationships manually. In EF Core as part of .NET 5 many-to-many relationships by convention was one of the most expected features. Together with the DbContextFactory useful for Blazor Apps and deskop apps (yes you can create .NET COre WPF apps)/
@@Codewrinkles what I mean is the following, for example, in a shopping app there is an Order entity, which can contain many Products (which consists of 1 product), Bundle (which consists of multiple products, but is coded as a separate entity and an order can contain many bundles in it), and let's say an entity named DiscountCode contains discount codes the user can use to get discount for an order (can use multiple codes per order), making the Order entity result of a many to many to many relationship. What I mean is, can this technique be used to create such entities? Sorry if the example mentioned is not the best, I just thought of it on the fly...
@@chezchezchezchez the music is not the problem, is your pathetic level of attention to the guys explanation, he’s even speaking loudly and everything is clear
Hello Sir, I have followed your tutorial and configured the many to many relationship via the Model Builder. Now I have a problem, how can I perform the CRUD queries in C#? I get an error in the intellisense saying that I cannot convert from a class model to a class join model (for example, cannot convert from Movie to MovieWatchList). Do you have tutorials covering this? Please I need help.
@@ramimuddin7925 I'm really sorry I missed your question. As it is the same, my previous reply also applies to you. Could you post the code that showcases what you are trying to achieve?
@@Codewrinkles no problem sir. I actually found a way to sort it out. Hopefully, everything is working but is still a bit annoying that there’s no documentation explaining how to handle and query many to many relationships. Maybe that might be a new content to create for your channel 😊
And please ignore my previous reply, it seemed rude, it wasn’t directed to you but to someone who doesn’t even know how to put a proper sentence in plain English. Anyway thanks for your reply and please keep making content. It is really helpful 👍🏽
@@ramimuddin7925 No problem. I'm just trying to help. A video on working with many to many relationships is now on my to do list :). However, I can't estimate a timeline since these weeks I'm fairly busy with work and personal stuff.
Thank you so much! Well explained even for a Brazilian guy like me, who has English as a secondary language.
One of the best videos explaining this! I’m using it to help build an iOS PassKit web service. The many to many requirement of the Device and Pass seem to map nicely to Author/Book. Thanks!
Glad it helped!
@@Codewrinkles ya I’m pretty much finished with the project now. Thanks again!
Hello Sir, I have followed your tutorial and configured the many to many relationship via the Model Builder. Now I have a problem, how can I perform the CRUD queries in C#?
I get an error in the intellisense saying that I cannot convert from a class model to a class join model (for example, cannot convert from Movie to MovieWatchList). Do you have tutorials covering this? Please I need help.
have you figured it out?
@@dyaaCoding honestly I can’t remember, it was quite a long time ago
Your music didn’t bother me I found your video very helpful after watching your one to many relationship video. Thank you
Glad it was helpful!
LOL funny stuff
Any advice on how you would set this up using DDD?
Am I missing something? Is this how this was done before? Anyhow, nowadays just put ICollection on both classes and entity fc will handle everything else
Yes, things have changed in EF 5 (EF Core 5). To be honest, it's a total mess with different EF versions. For instance on EF for .NET Framework many-to-many relationships are configured by convention (as you said) for quite a few years. However, in EF Core this was never possible and you would need an object for the joining table and configure the relationships manually. In EF Core as part of .NET 5 many-to-many relationships by convention was one of the most expected features. Together with the DbContextFactory useful for Blazor Apps and deskop apps (yes you can create .NET COre WPF apps)/
Thanl your for the video. But I still have one question. How to update. Can you explain to me how to with update many-to-many relatinship tables?
Here's a brand new video that might help answer this question: th-cam.com/video/jNW-uCPmIBU/w-d-xo.html
DUDE !!! YOU SAVE MY LIFE!!
Glad to hear that :)
@@Codewrinkles Love you man, keep up the good work.
I have wasted a lot of time trying to figure this out, thank you so much
how to query the table book and author ?
Thank you so much for the video
Great content, love the passion
Hopefully you watched also the most recent videos. There's even more passion!
Hello sir, How will i seed data in These table using EFCore i am facing difficulty in this many to many relationship. kindly suugest .
I think this video might have the answers you are looking for: th-cam.com/video/66UmXtiub90/w-d-xo.html
@@Codewrinkles Thank you !!
super clean and time-saving, although I m using java, it makes sense to me
Glad you liked it. The Java and DotNet ecosystem have a lot of things in common.
Great video helped me with school thanks
Glad it helped!
Can this very same approach be used to define triple many to many to many relationships?
Not sure exactly what you mean, but I guess the answer is yes. An entity can be involved in several many-to-many relationship at the same time.
@@Codewrinkles what I mean is the following, for example, in a shopping app there is an Order entity, which can contain many Products (which consists of 1 product), Bundle (which consists of multiple products, but is coded as a separate entity and an order can contain many bundles in it), and let's say an entity named DiscountCode contains discount codes the user can use to get discount for an order (can use multiple codes per order), making the Order entity result of a many to many to many relationship. What I mean is, can this technique be used to create such entities?
Sorry if the example mentioned is not the best, I just thought of it on the fly...
Hello Sir, i liked your video, you explained well the content and you took away all my doubts :-)
Glad to hear that. Fortunately, starting EF5 everything is easier as many to many relationships are also created by convention.
Thank you helps alot
plz get rid of background music on your upcoming videos
Is the background music so bothering?
@@Codewrinkles yes! It’s terrible.
How did you come up with such a dumb idea?
These guys are very alone in their views. Background music 100% is fine and good.
@@chezchezchezchez the music is not the problem, is your pathetic level of attention to the guys explanation, he’s even speaking loudly and everything is clear
He doesn’t have to, as the explanation is clear
Very very good, Thanks a lot
Most welcome
Hello Sir, I have followed your tutorial and configured the many to many relationship via the Model Builder. Now I have a problem, how can I perform the CRUD queries in C#?
I get an error in the intellisense saying that I cannot convert from a class model to a class join model (for example, cannot convert from Movie to MovieWatchList). Do you have tutorials covering this? Please I need help.
Can you post the code of what you are trying to do?
@@ramimuddin7925 I'm really sorry I missed your question. As it is the same, my previous reply also applies to you. Could you post the code that showcases what you are trying to achieve?
@@Codewrinkles no problem sir. I actually found a way to sort it out. Hopefully, everything is working but is still a bit annoying that there’s no documentation explaining how to handle and query many to many relationships. Maybe that might be a new content to create for your channel 😊
And please ignore my previous reply, it seemed rude, it wasn’t directed to you but to someone who doesn’t even know how to put a proper sentence in plain English. Anyway thanks for your reply and please keep making content. It is really helpful 👍🏽
@@ramimuddin7925 No problem. I'm just trying to help. A video on working with many to many relationships is now on my to do list :). However, I can't estimate a timeline since these weeks I'm fairly busy with work and personal stuff.