ASP .NET Core MVC CRUD Operations with Foreign key using CodeFirst Approach

From this tutorial you will learn to use the Foreign Key Attribute
in Entity Framework Core to configure the Foreign Key Property.
We use the Foreign Key to define the relationship between tables in the database.
For Example, In Our Inventory Manager Project, which we are doing
for couple of months now.
Every Product has a Measurement of Unit, like PCS, Liters, Kgs etc.
Our Product table is in relationship with the unit table.
I mean, The name and description of the unit is stored in the unit Table
and the unitId is stored in the Product table.
We express this relationship by creating a UnitID Column
in the Product table and marking it as Foreign Key.
In this example, the Unit is the Principal entity & Product is a Dependent entity.
From this tutorial You will also learn how to use multiple repositories
from a Single Controller. In our Project Unit details can be only accessed
by the Unit Repository. Whereas Our Product controller needs to read unit
details from the units table.
So how to solve this issue. watch it I bet you like it.
and also you will learn in detail about the importance of Migration Commands and Pagination feature to the CRUD.
It also explains the Sorting and Searching feature of the CRUD clearly.
Then we will see the benefit of using the smallmoney datatype over float.
and we will learn what is one-to-one relation and one-to-many relation.
after that I Will show you how to create the Foreign key constraint
between Multiple Tables.
Finally I am very happy to share the sourcecode url of this application
inside this video.
and Much More....
So please watch and put your comments.
Sorting Module link
• ASP.NET CORE EFCORE MV...
previous Part Link.
• ASP .NET Core 5 MVC pr...
Playlist Link
• Asp net core 5 MVC Tut...
Thanks
Aniz

[@eintech6566]

You are correct Aniz, Many of tutorials listed on TH-cam are designed on single table and far from real world applications. Excellent effort. Keep up the good work.

[@CodeSbyAniz]

Appreciate your response. Thank you.

[@farrukhazadpak5149]

thanks for excellent work , you solve my problem , I search this video for 2 weeks , thanks dear friend , i Like .

[@CodeSbyAniz]

You are most welcome. Stay tuned to the channel.

[@azoredjyamo68]

Very interesting for beginners

[@franklint8301]

Thank You My Friend, very detailed explanation. by the way thanks for the source code, I like the idea of showing the password after 15 minutes of the video. clever. lol...

[@CodeSbyAniz]

You are Most welcome!

[@itbattalion194]

very informative

[@huntercyberdarkcyber4855]

Haha thank you for posting this mate! Very helpful

[@CodeSbyAniz]

You are most welcome. Happy Coding.

[@melisarafoles3066]

Excellent Work. please release frequently. Thank You

[@CodeSbyAniz]

Welcome and Cheers!!!. I will try my best

[@purnarana9081]

Thank You , waiting for the next part.

[@CodeSbyAniz]

You are welcome and coming soon.

[@zenpaiempire]

can we have tutorial on creating web API's showing foreign key integrity and consuming those Web APIs from diffrent MVC web application.

[@NadunUdana]

thanks man

[@bahhmantahmasebi]

nice

[@DanielRezendePessoa]

Awesome!

[@CodeSbyAniz]

Thank you! Cheers!

[@farrukhazadpak5149]

plz upload any work related to user role and user access rights and how to upload any project to server

[@CodeSbyAniz]

Definitely, will do. Stay Tuned.

[@Defense89]

wow thx alot!!!! your tutorial was awesome!!! but how to do it with an api? like postman how to pass complexe data in the postman's json format?

[@CodeSbyAniz]

You are most welcome. very soon I will create videos on API. the whole idea is to convert this project in to microservices using API's. Actually I am little busy in my office project. will definitely do it when time permits.

[@kholerohit4323]

Bro can u share link of full source code because it's half source code there is not main products in it plz send link of full source code ASAP

[@CodeSbyAniz]

soon will be sharing the code with products model.

[@kamajo7518]

Hi Aniz, thanks again for the helpful video, it had some benefit. But the problem is that if you use restrictions in the repository for the delete method, then the items cannot be edited or changed. Any idea how to solve this problem? Thanks for your videos, they are very enjoyable and sometimes I laugh with you! :)

[@CodeSbyAniz]

Thanks for watching. But why it cannot be edited or changed. it can be modified very much. could you please explain your doubt clearly. and tell me where you face the issues?

[@kamajo7518]

@@CodeSbyAniz Hi Aniz, yes. So when I try to change or update my product record I get an exception that goes like this: “ The property 'Product.ProductId' has a temporary value while attempting to change the entity's state to 'Modified'. Either set a permanent value explicitly, or ensure that the database is configured to generate values for this property.“ I have a larger application and I use a remote DB. It is difficult to briefly describe the issue here in the comments. Maybe a bug on the ASP.Net side? And just for information, I'm using ASP.Net core 6 for my needs.
Thanks for your replay. Kamil

[@DailySpace16]

why you use paginatedlist in getunit method . can you explain about it more. is there another way to bind unit item ?

[@CodeSbyAniz]

yes , you can do without paginated list also. There is a video of the same concept without paginated list.
please watch this th-cam.com/video/O57nsLyZubc/w-d-xo.html

[@attiqurrahman5573]

Thanks, do u have a playlist where u explain everything of this project from zero ?

[@CodeSbyAniz]

Welcome. playlist is the description of the video. please check. Thank you.

[@АлександрКудрявцев-щ9ъ]

Good afternoon, Thank you very much for your work.
An error occurred, "The field Cost must be a number".
The code is exactly like yours.

[@CodeSbyAniz]

I did not get any error. could you please send a detail with screen shots to [e-mail]. Thanks

[@anbuanbu6591]

Hi, why we use interface? we directly use product repository. Kindly provide reason for interface repository.

[@CodeSbyAniz]

I am planning to release a video on interfaces. on that time this will get cleared.

[@abdullahquhtani4247]

Do you do paid tasks?

[@CodeSbyAniz]

Sorry , I am very busy now.

[@clovisrodyt]

Sorry, but... Is the source code file password protected ? Thanks

[@CodeSbyAniz]

Welcome, Password is shown in the video. please watch the video.

[@bahhmantahmasebi]

@@CodeSbyAniz i watched the whole video but password doesn't appear dude

[@kholerohit4323]

@@bahhmantahmasebi Vr@2022

[@ramuninavya2357]

@@bahhmantahmasebi hi did u get source code link?? If yes,plz can u share that??

[@bahhmantahmasebi]

@@ramuninavya2357 you can see the source code link at first of video,copy the exact link and past it in browser then it begins to download,you can find the zip file password in comments

[@mebinayasharma]

How can I refer to two foreign keys from a single table?

[@CodeSbyAniz]

the products table is referenced from many tables like brand , category, unit etc. please watch full video.

[@דניאלר-ע4ו]

I'm trying to download the code but it requires a password

[@CodeSbyAniz]

but password is shown in the video, so please watch without skipping the video.

[@justshukri9407]

You didn't show how to create that repository

[@CodeSbyAniz]

please follow the playlist. everything is shown from the scratch.

[@kashanzafar1662]

@@CodeSbyAniz What is Password of Zip file

[@minettembouh1598]

Please, I cannot access the source code

[@CodeSbyAniz]

please check, the link is very much working.

[@AbdilahiTahir]

Where is the link😢

[@CodeSbyAniz]

please watch the full video without skipping , source code URL will appear in the middle. Thanks.

[@santoshanand4867]

@@CodeSbyAniz password of zip??

[@motivationalbeast3569]

Source code link?

[@CodeSbyAniz]

Source code link is in the video.

[@aamirnawab2920]

Not working

[@kashanzafar1662]

Please Share the Password of Zip File

[@nilaykShah]

Horrible way to demonstrate some thing. Doing copying and pasting.