.NET 6 & EF Core 🚀 ALL Relationships (1:1, 1:n, n:n) with Entity Framework Core 6 & SQL Server

[@PatrickGod]

🚀 Join the .NET Web Academy with a 30% discount - closing soon! 👉 www.dotnetwebacademy.com/courses/academy?coupon=dnwas23yt

[@azamjandali867]

The fact that you code and fix error live makes you an elite programming content creator!

[@PatrickGod]

Thank you so much! Appreciate it! 😊

[@oncalldev]

Seeing the real world coding of encountering errors and troubleshooting just adds a better understanding to the overall subject matter - as was the case here. Thanks for the highly understandable & enjoyable content.

[@PatrickGod]

Thank you so much Bruce, appreciate it! 😊

[@egabrielbootcamp]

It was interesting watching it. I just couldn't help but laugh at some point because it was so relatable :)

[@parapadirapa]

And why not just have a userId FK in the Character? Why are you building Models that contain both the referrenced objects (the User property within the Character) AND their ID (the UserId)? Why should the Character contain a property of the User object? Does EF require it for the FK to be created? (I don't think so, or else the UserId would be not be needed. Makes sense?). In essence, why shouldn't just the ID of the foreign object be enough?...

[@R5123]

I had the same question. EF uses it for the foreign key to be created. They are called "Navigation Properties." They aren't loaded unless you explicitly load the relationships in your queries of the DbContext. That said, I am still not sure why he couldn't save the character around the 29:00 mark when he had specified the userId. Seems strange to me that you would have to run a query to find the user before adding the character entry to the database given you are supplying a valid foreign key there.

[@alexandrivanitskyi9350]

I thing that's awful, sorry. I going to yt to see correct example with ef6, another side, i see how to guy trying make working code and in the end it doesn't look like correct decision. i hope you understand about what i say

[@grumpydeveloper69]

I like the messy style of this video and that fact that you did not prepare a lot in advance. This feels lot like how I approach things and then run into the type of problems you ran into. And... I like your cussing as well, very recognizable 🙂

[@PatrickGod]

Haha, thank you so much. Yeah, that's just the way it is. Sometimes you just don't know what problems you're going to run into. Even with supposedly simple tasks. 😅

[@tylerb6981]

My favourite part was when he acknowledged how much easier this process would be with the proper software architecture. It is a testament to the efficacy of the architecture, his knowledge level, and the nuances of using a framework as complex as .NET.

[@Raziel7171]

You have no idea how helpful this tutorial was to me, i don't even speak english but the voice is so clear and neutral didn't needed a close captions and the errors I've been struggling lately has been solved so quick, thank you so much.

[@sergkapitan2578]

LIke and subscription!!!!! Cab you create a video with the same content for those who are "left behind":))) For those who want to learn the framework , but still not that far!? There are many confusions, when it come to which combination of "tools" is better. Is MVC is still relevant in such a dev.? When is better "Code first"? And how to connect this with FRONTEND tool, ...specially as Angular :) Really many thanks!!!

[@sergkapitan2578]

Patrick! Everything is great:) But for those who are not familiar with this framework and some other stuff it is too heavy without little more explanaitions in the first place! Is it possible for you to expand this video or create an additional tutorial for this one as forrunner:)??? That would be great help for many people as I see also greatfule dudes in the commentaries. Some basic explanaitions would also not be too much! Thank you once again for your generosity and service!!! God bless you :)

[@Big_Dai]

Mr God.. where was this Swagger UI thingy configured? Came out of nowhere, seems REALLY useful, and I don't think it was configured anywhere in this video. Do you have any resources for it?

[@mohameddabbour6961]

To solve that add error, Just change User property in Character model to be: public User? User { get; set; } the ? means optional

[@Syberytowy]

it means nullable to be precise, which is quite important i think

[@orhanaliyev9774]

1 : 1 you started writing completely wrong .... honestly, no offense, it was possible to put the whole video in 15 minutes .... probably it was still worth flipping through the documentation before recording the video

[@manofqwerty]

Just use a Dto for the creation of a Character and you will be AOK!

[@katrykonig2466]

How and what would you do if both Charachter and User belong to two different assemblies ? How could you reference both sides? You fall in a Circular Dependencies !!

[@LeandroSouza-vl7cl]

You should change the title of this video to "For beginners" because it is a really junior way to work with EF. For something more professional in the real world, I would suggest you use Fluent API with configurators.

[@katrykonig2466]

I don't believe the ER Model is a clear structure, you add a user and userId as a data type to characters class, which is not a good way to manage the relationship between Users & Characters

[@bristolboer2910]

For a man with a surname of God I understand why you are saying Jesus Christ a lot in your video!

[@leonnxpumper]

Thank you so much for your videos! I can't believe how fluent and easy going are your videos. English is not my first language but your pronuntiation and your pace make it easy to understand everything.

[@PatrickGod]

Happy to hear that! Thank you so much for your feedback! 😊

[@davittonoyan6537]

Great video) Can you make video about API authentication?

[@mauroinde]

You are light in the c# darkness Please use more MongoDB

[@paollarce5137]

Do you know how can I add another field to the CharacterSkill table?

[@jeverydk]

The only constructive feedback i have is that: 1. You should have shown in code, how you added entities to your database, instead of doing it directly in the database. Else its been a great video. 2. When you debug, mouse over the error you find and explain to problemshooting logic from what you are reading/seeing :)

[@PatrickGod]

Thanks a lot for the feedback! It seems I'm too fast sometimes, in particular when I get any errors. I'll keep that in mind. 😊

[@jeverydk]

@@PatrickGod watching you problemsolve error was one of those things i learned most of. In generel was it so refreshing too see errors in a "tutorial" and i learned a bunch.

[@muzamilmughal-15]

I loved your approach of using DTO but that actual error could be resolved by just making it Nullable, because for making a relationship we just need the Id of that particular object, not the complete object. Because even when using DTO we are making extra round trip to DB for getting the USER against specific userId which is not essential in this particular case.

[@HarshJoshi-j6r]

Does it works?

[@АристархЗловредович]

Stumbled upon your channel by accident, great content and very clear explanations. Best regards from Azerbaijan

[@PatrickGod]

Thank you so much! Appreciate it! 😁

[@waliqadri]

Wow, I can't thank you enough for all the errors that have surfaced in this video! Believe it or not, your troubleshooting with these errors actually elevates it to premium content. Embracing imperfections while learning programming makes the journey more relatable and enjoyable. This video becomes a delightful blend of education and entertainment, showing that even experts encounter challenges. Kudos to the creator for sharing real-life problem-solving, turning it into an inspiring and insightful experience. Double-tap if you agree that this video is a gem amidst the sea of polished content! 💎🎉 #ProgrammingPassion #EmbracingMistakes #PremiumContent"

[@dorlugasigal]

setting [JsonIgnore] doesnt really fix, what will happen when an analytics team wants to get the Skills and the characters that are using them?

[@Tresla]

I'm also running into this problem right now. I want both sides of the relationship to be visible via the API, with the relationship optionally eager loaded through a "fields"/"include" query parameter. How would one resolve this?

[@marcosdalmolin357]

Gracias por tu pronunciación! No se mucho inglés pero hablas muy pausado y eso ayuda mucho para entender lo que dices. Ojalá tuvieras los subs en español, pero se agradece mucho tu contenido. Saludos desde Argentina.

[@graynoble4795]

Patrick, thank you for this demo. It helps me in becoming more familiar with EF!!!! P.S. I would love to see all of those "what you should do is.... " best practices :)

[@SZOKE19940321]

Ur the best Patrick, was googling for like 2 hours now, could not put it together, found your video, it just saved me another few hours of searching. Really helpful the live debugging from ur side. Cheers man!

[@PatrickGod]

Thank you so much for letting me know. Really glad I could help! 😊

[@mattmsmith]

Note: The onModelCreating is not used here explicitly. This is because a join table CharacterSkill that was implicitly created does NOT have its own unique properties. The n:n entity relationship is implicit onModelCreating. If for example, the Character that adds a skill needs to have a date or level of skill associated with him, we would explicitly add the CharacterSkill model (Composite table) with those unique properties.

[@goditto5694]

actually, public class User { public int UserId { get; set; } public string UserName { get; set; } public virtual ICollection CharacterUsers { get; set; } } public class Character { public int CharacterId { get; set; } public string CharacterName { get; set; } public virtual ICollection CharacterUsers { get; set; } } public class CharacterUser { public int UserId { get; set; } public User User { get; set; } public int CharacterId { get; set; } public Character Character { get; set; } } isn't N:N relationship btw 2?

[@unkn0wnrge189]

you are the obi wan kenobi of C# you deserve coffee so the force will be with you

[@PatrickGod]

Thank you so much!!

[@lalitkumarshahi]

I recently started to watch your videos, liked most of them. Please create video on .net web api solution architecture

[@R5123]

Hey really nice video Patrick! The many-to-many has tripped me up in the past so thanks for taking the time to walk through that.

[@PatrickGod]

Glad it was helpful! Thanks a lot for your feedback!

[@rankarat]

This is my 1st EF tutorial, i worked only with NoSQL DBs, thought i will give it a try, this was very fun to watch! thanks.

[@PatrickGod]

Glad you enjoyed it! Thanks a lot for your feedback! 😊

[@rafaelgarcia2259]

It was tricky to fight with dotnet ef, because I had to build the solution, the project, hahaha, until it wants to do its work right (same code). But I have learned a lot from the errors, thank you to be a fighter against errors and show them and their resolution.

[@PatrickGod]

Thanks a lot for your feedback! Great you figured it out! 😊

[@brentdar4568]

Thanks for the tip about build the solution, I was stuck for the moment there.

[@Deltacasper]

I get this error with this relationship: "Introducing FOREIGN KEY constraint 'FK_Events_Users_UserId' on table 'Events' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints". How can I fix this?

[@techwithstephen]

Hy,really love your videos. Just one question: which presentation software are you using for your slides really love it.

[@PatrickGod]

Thanks a lot! I use "Canva" for the slides. Enjoy! 😊

[@kapiercy11]

The error that you encountered with the POST method is EXACTLY what I was dealing with after watching your CRUD with a .NET 6 Web API & Entity Framework Core 🚀 Full Course and tailoring it along the way to my use case. Post was requiring the object and I could not for the life of me determine why.

[@willgale7187]

fuuuuuck, this video is amazing! binging all your content and learning so much :)

[@PatrickGod]

Thank you so much! Glad you like it! 😊

[@willgale7187]

@@PatrickGod Such quality content my friend, much appreciated

[@Wada-Channel]

Hi, great video! I'm a newbie. Could you please suggest if it would be a good idea to create a WinForms app that interacts with a Web API, with the possibility of developing another frontend for a mobile app if needed

[@lolilops54]

It seems to me that EF can handle relationships in the database, but it comes at the cost of making your classes unusable for every other context. The circular relationship you showed here is a massive red flag. Also, you can't query a user and get all their characters. You have to just query the user with an empty character collection, query the characters separately, and then what? You can't relate them in code due to their circular relationship. A complete user object would include all the user's characters, but this setup completely prohibits that. Honestly, thanks for the info, but I don't think this is a good approach. If you ever have a class X referencing Y, and Y referencing X, then refactor. Don't let EF enforce bad practises on you.

[@sardar3317]

Your name translates in Arabic/ Urdu as "Azeem Ullah"... It is pretty much like Muslim names.

[@CreativeRosh]

I love the way you doing that tutorials. You never hide error. I really appreciate that. really interesting. Pleas don't change your Style. Thank you And Good luck brother!

[@PatrickGod]

I appreciate that! Thank you so much for your feedback! 😊

[@juergenriemer]

Nice video.. like your jokes :) .. BTW: as for the issue with saving the Character.. you could set User as nullifyable in the Character class.. this should also work

[@unkn0wnrge189]

"Why I never learn this" about JSONIgnore, that made me laugh, cool see live coding, some times I ask the same thing myself after doing same mistake for 10 years, my dad said if you don't get it after 3 times you are stupid lol, then we are both stupid.

[@MkYentertainment]

The protected override void OnModelCreating(ModelBuilder modelBuilder) method is not necessary ?

[@waliqadri]

Where you are getting a list of characters if you use Include("Users") right after the where() method, every users entity in each Character entity will be populated with the related data! Auto-magic-ally

[@thanhtc1988]

Thanks Patrick a lot but can you add the auto generated subtitles English pls, it make non-native English speakers easier to follow.

[@bendesimt]

Nice tutorial but it would have been really nice if you told us that we need to install Microsoft SQL express server in order for the database to work. It's kind of obvious now but I wasted a lot of time trying to understand why the database wasn't working.

[@MagnusYnglov]

Hi and thanks for nice videos! Is it possible to debug these autogenerated code within entitity framweworks?

[@StarLakeFarm]

I did not enjoy this video. You made a lot of mistakes. After making the videos, you should have edited the video to remove the mistakes. Felt very confused at end of video

[@R5123]

Lol at 33:32 "Well that was a lot of work for just creating a character" :D

[@jeremiahcubong4445]

Hi Patrick, Firstly I must commend your efforts, you are doing a very good job there. I was following the video, and I got stuck at the many to many relationship part. I have created a class for skills, and added the List of skills to my character class also, but when I run the ef migrate command, I only get the skills table, I do not get the combined table of skills and character. Is there something I am doing wrong?

[@donal9914]

.NET 6 & Authentification

[@ArthunMorgan747]

but how we can use this concept with angular? I know you talked about backend relationships here but how is it going to help in frontend ?

[@santosh.nextbuild]

If both tables have primary key is string datatype, it is not working. why? And how do you work?

[@richaaggarwal4165]

great video but i have one question the configuration code is different for .net6 and .net 7 and can you make a detailed video on what's new in .net7

[@samiullah0011]

what does the return type Task, IActionResult and ActionResult do?

[@Uzair_Anwar2299]

Can two project with different models point to a same database?? I want user app and admin app independently but with same database

[@KathyDally]

You saved my project, I was having the same error with the foreign keys, sending the object from the client side to the API and just getting a Bad Request. Thanks a lot for your detail troubleshooting. =)

[@PatrickGod]

Glad I could help! Thanks so much for your feedback! 😊

[@suzy.no_losey]

It may have been a good idea to have built a sample prior to recording the video instead of fumbling through and coding ad hoc

[@emwagner]

Wouldn't ICollection be faster than List?

[@Time21]

subscribed to your newsletter and when i press the confirm button on the mail it redirects me to a 404 page. Are you aware of that issue?

[@PatrickGod]

Thanks a lot for subscribing and for the info, Nick! I hope that's fixed with my latest landing page for the newsletter.

[@R5123]

Also, get ready for a new energy at 58:28 :D

[@بيبروفيسورفيالرياضيات-ض1ج]

thanks great video I want ask in 23:57 why user is null?

[@Cursix]

I have a question if u put [key] on the models does it then not work?

[@josbexerr5166]

Gracias mister patrick se entiende a pesar que no esta activado los subtitulos :(

[@Uzair_Anwar2299]

Can you create a video on database first approach.

[@Don-ii4vm]

In less than a year, you've tripled your subscriber numbers. Well Done, Patrick.

[@PatrickGod]

Thank you! 😊

[@joaovitordossantos8669]

I'm from Brazil and u are helping me a lot, thanks!!

[@PatrickGod]

Happy to help! 😊

[@josbexerra8115]

Gracias Mister Patrick......A pesar que no tiene subtítulos, se entiende....

[@PatrickGod]

Glad I could help! 😄

[@kdu97]

Really appreciate this,thak you!

[@Gauravkumar-jm4ve]

Nice.. thanks for sharing.. please keep doing more

[@PatrickGod]

Thanks a lot for your feedback!

[@cihangullu333]

Thank you so much.

[@PatrickGod]

You're welcome! 😊

[@ferdicuyar814]

I am at the half of the video. You cant make a http post becouse user got characters and characters got users. application can not come into the function. But u keep changing function code. But dude app can not come in to the function :) I usely play on json class and record on actual class. exmple; we got to record on character here. I create CharacterJson class and give no relationship. so when i post this class i can enter in function. than record on db as how you want.

[@ferdicuyar814]

in 32:32 i cant confirm without trying but u may use virtual list and virtual user properties than u wont need jsonignore annatation.

[@suleyman8843]

i loved your videos. I'm learning a lot from you, thank you

[@PatrickGod]

Thank you so much for your feedback! Glad you like them! 😊

[@muharremkackn2202]

Patrick, I loved learning dotnet from you!

[@PatrickGod]

Thank you very much! Appreciate it! ☺

[@mannamramakrishna4847]

Hii Sir, A Small Doubt, When to use [JsonIgnore]. And in which Class file we will use [JsonIgnore]

[@ahmadtarkashvand8289]

hi, how can I get source codes

[@docris8036]

Finally found my best problem solving video. Thank you my teacher

[@dddanielsr]

Thank you Patrick!!! I've been struggling with EF for the last two weeks.... Now I think I see the light at the end of the tunnel... :)

[@Toughmenchannel]

Can you film a video to explain why there is need to Create the CreateCharacterDTO in the 1 : n relationship. ; and approach to handle the 1 object to avoid the cycle reference? those seems interesting for me. Thanks.

[@aminouadrani2995]

Thank you

[@PatrickGod]

Most welcome! 😊

[@modx5534]

Great Tutorial and I nice video-Cheatsheet ^^. I just needed a refresher in ef core and some bugfixing tips for example how to deal with the json-serialization error. Your video helped me a great deal with that. Thanks!

[@steliospapadopoulos4589]

I was looking for a fix in those errors you encountered. I could not find any recourses on the internet and it seems like I found the fix. I am using pomelo entity framework and MySQL .I hope it will work. Many thanks and cheers to the no script tutorial!

[@sobrelaroca2701]

Hi, I want to make a character update. But when I add or update a character attaching the relational objects to it (that already exists on database), the savechanges method attempts to create them into database, I don't want to create just to assign existing skills to character.

[@surprisedduck6750]

Do you have any videos on how I can go about actually calling my Web API from a blazor app for example?

[@OleksandrRohozilnikov]

Thanks god i found you dude, awesome tutorial and btw its pretty fun to watch its because of your way to solve the issues while tutorial. Its really helps me, thanks a lot!

[@sagarmajumdar92]

Hi Patrick Weapon has character and characterid . Character has user and userid. When you added a new Character you added the userid and not user but when you added the weapon you added the character and not the characterid (at 46:00) . Why is this different ?

[@2005bgva]

Patrick thanks for this video. Could you please activate subtitles?

[@galaxy1066]

Hello Dear Patrick, would you open automatic translate(cc)

[@01pedro02pedrinho03]

Really good content, helped me a lot, thanks!!

[@PatrickGod]

Thank you so much for your feedback! 😄

[@HiTab_Software]

Hi Everyone, I had a project in which I had to use the JsonIgnore Attribute, but for data binding I had the problem that the table related could not be accessed. The solution I found was creating an object using Select in you controller query. For example: ```_context.Weapon .Select(w = new { w.Id, w.name, Character = w. Character .Select(c = new { c.Id, etc etc }).ToList() }).ToListAsync(); ```

[@fahadsm7006]

Thanks!

[@PatrickGod]

Wow! Thank you so much! 😀

[@hghmnds]

+1 sub

[@PatrickGod]

Thank you so much! 😊

[@alexkal820]

Of course its worth a like! good job and thank you

[@BhagirathMakwana-e1y]

Good explaination

[@BhagirathMakwana-e1y]

good explaination

[@BolsaCast365]

adds subtitles so that we Brazilians can follow the course.