Asp.Net Core MVC Web App CRUD with EF Core

[@CodAffection]

goo.gl/bPcyXW : Buy me a Coffee bit.ly/36IA1cH : Latest Video on This Same Topic bit.ly/3muhseC : CRUD without EF in AspNet Core MVC bit.ly/3Pn2S7y : Expense Tracker App in AspNet Core MVC bit.ly/403lUVC : MVC Login & User Registration bit.ly/2yEPlpB : Convert MVC App to Single Page bit.ly/39B6xdh : Image Upload in AspNet Core MVC bit.ly/3MkPZex : A to Z about AspNet Core Identity with .Net Core API

[@blackclover5561]

Can you please show us how to make and use Data Transfer Objects and actually explain them how they work? Greetings from Macedonia!

[@sayedbintaher2664]

I was given an assignment for the job I applied to and I had no experience with C# before. Glad I got this video. Thanks alot for uploading a detailed CRUD video.

[@ngocthinh3935]

first all of. I am really thank you for your video. I am a third-year student in VietNam and I am starting learning dotnet core mvc web application. so I really appreciate your video and this very helpful for me. Thank you for creating an excellent course

[@peytonnaomi]

This was an excellent course. Thank you for explaining the reason behind the code to bring all the concepts together. I've paid for courses that were not this well thought out. Awesome job!

[@CodAffection]

Thanks for the wonderful feedback.

[@default632]

Your accent is very clear sir, good job. And you explain nicely

[@mihaistoian_]

Thank you very much! This video helped me pass my Web Applications Design lab exam. It is very hard to find a good and really helpfully video like this. Thank you again!

[@milyyybarrrr9216]

Thank you very much!!! I would be very happy if you were my teacher! You explain very well and you follow the logic of code construction. Continue to do like this!

[@CodAffection]

Glad I could help! Thanks for your wonderful feedback.

[@gaganmudvari1553]

thank you for this mvc core with EF core Crud operation. please make series of this mvc core . thanks alot for this. waiting for your complete series of this MVC core 2 series. god bless you. takecare

[@مطورويب-ش7د]

Thanks a lot . we need more in .net core and angular

[@CodAffection]

sure. I'm working on it.

[@ShivamSingh-wh9jj]

@@CodAffection I'm waiting for it

[@CodAffection]

@@ShivamSingh-wh9jj don't you get the notification about my yesterday video - angular inline table editing

[@ShivamSingh-wh9jj]

@@CodAffection Oh sorry 😅

[@kvsnvsnk2969]

thanks! sir for the awesome very useful video on asp.net ef core, very clear and immaculate presentation

[@jonathanascano]

Please keep making videos, This helps a lot. Thank you

[@bhaskarmanna8077]

thank you so much sir, this is an awesome tutorial on .net core

[@sourabhpanchal9819]

This tutorial is awesome .... please record full .net core tutorial session .. Thanks a lot for this tutorial

[@CodAffection]

Glad you found the tutorial helpful.

[@jackfrost8969]

if you are using .net core 3 then you will need these two extra packages: Microsoft.EntityFrameworkCore.SqlServer -> to use UseSqlServer Microsoft.EntityFrameworkCore.Tools -> to use migration commands It's a hassle with all these new versions. To save youself from potential errors just install these packages before beginning the tutorial.

[@raymondorenda7385]

Nice Video there. Please upload videos on ways to add new column or delete one dynamically with MVC without having to recode the view model.

[@kjin3826]

Thank you so much for the good tutorial! Keep up the awesome work

[@Foodie363]

Code affection u r legend! and those who are using Core 3.0 guys u need to install Microsoft.EntityFrameworkCore.Tools at nuget package mangers

[@abdullaalblooshi2406]

I think no need, it was already installed for me

[@cedricparfait4854]

Really Helpful thank you very much for this clear explanation, hope for more videos

[@BladeSlayerr]

You've possibly saved my project :). i tried to do this using your other video on MVc Framework, but i was so confused on what to do and where. thank you so much.

[@CodAffection]

thanks for your wonderful feedback.

[@savyayadav191]

Thank you so much for this video. it's awesome for MVC beginners.

[@CodAffection]

glad you found the video helpful.

[@hiraawan3430]

great video. I created my first project so easily..

[@CodAffection]

Keep it up

[@omarayub1295]

Brilliant Good Going bro...learned a lot thanks.......

[@kuldeepnarayanminj]

Thankyou so much, one of the best tutorial out there.

[@CodAffection]

Glad you think so!

[@frankponte7261]

Excellent! You helped me to begin work with this framework. Thank you!!!!

[@CodAffection]

thanks for the comment. glad you found it helpful.

[@smirceageorge5057]

Real nice mate! I appreciate your videos a lot!

[@AdityaSingh-yb3ii]

Wonderful explanation. Thank you

[@FranciscoBurgos30]

Hi! Excelent tutorial. But I've a Question. What happend if I've a project with identity and alredy exist an authDBContext and SQL DB? we will work with separately DB and conext or we use de same DB with a new context?

[@CodAffection]

Not tried the same DB with multiple contexts. if you are using a single DB for both, it would be better not to create more than one DB context. might be a problem with the concurrent operation (not sure). If you are keeping separate DBs, then you must need two separate contexts. you can avoid mixing identity tables with yours. but you also need to consider the expense it comes with - cost, ram usage, separate backup schedule, etc. Use one DB and one context if you developing a smaller application. if you don't want to mix the table with identity and you are fine with extra works, you can have two DBs. Following StackOverflow, Answers might be helpful. stackoverflow.com/a/24712033/4133590 stackoverflow.com/a/50379005/4133590

[@nournote]

Again, very instructive. Just excellent! Can you please another project with: - roles and permissions management, preferably Active Directory based as it is the most in use in corporate environment - master-detail Thanks again. PS. A cup of coffee :)

[@saifchamsi8412]

Thank you so much we want more content with this quality

[@CodAffection]

sure.

[@DmitriMironov]

@@CodAffection I'd like to thank you so much. For sharing this onformation. Please keep recording new videos. I follow your tutorials and put the project on a github

[@agustinmoragues191]

Watchout on 19:37. I think it is an edition mistake. The 'TypeName' suddenly disappears. Must go on each attribute.

[@omarbousbia6916]

thank you so much, good and simple and straight forward tutorial

[@CodAffection]

thanks for the comment .let me know if you have any video suggestion in asp.net core.

[@ahmedshaabanelbehairy8417]

I love all of your tutorials, You Have a great Work, Thank You

[@CodAffection]

Glad you like them!

[@shauncs]

Simply explained. Appreciate your effort. Thanks!

[@SYO1Star]

Hey I think the create database part, you jump into the "microsoft SQL Server Management Studio" without showing how you actually connect to that?

[@peytonnaomi]

He covered how to connect to SQL server near the beginning of the video around the 12 min mark

[@osempo]

Thanks a lot, well explained and very wasy to understand. Im now subscribed and hope you upload some more ASP.NET Core tutorials.

[@CodAffection]

Sure.

[@zhouleeke8706]

AddorEdit function is really useful.

[@AshProgHelp]

very helpful video. clear to understand.

[@lukehoKim]

Very NICE tutorial. Thanks a lot.

[@CodAffection]

Glad you found the video helpful.

[@roshanzaid765]

This man is marvelous.

[@MartinFarouk]

Hi, Thanks for that useful & helpful content. But I have one question; while adding Employee.Controller (scaffholding) in 23:30; It always comes up with error "Package restore failed. Rolling back package changes...". I tried some online solutions but nothing worked out hence I am still stuck at that point. If you may help in that It would be great. Thanks again.

[@coolnavjot31]

Good explaination thank you

[@ammarmahmoud4422]

Can you share video haw to create USER with permission roles

[@thobanishezi2956]

Did you found help?

[@MauroBernal]

You have one example?

[@venkateshsana889]

i am not using any sql servers in my local pc. now while creating the DB we are unable create the tables so which DB we have to prefer according to the above video and what DB we have to install for the mvc

[@nickeax]

Thank you very much CodAffection, you have been a huge help!

[@elhaftaabdelaziz7272]

Awesome tutorial thank you , can you publish Asp.Net Core MVC Web App CRUD with EF Core and modal bootstrap ??

[@azadabdullahshaheed]

ASP.NET Core MVC and ASP.NET Core Razor are the same? Can I only learning ASP.NET Core MVC?

[@mubassiruddinfurqhan187]

even after getting nuGet package Microsoft.EntityFrameworkCore.Tools, when I iplement the concept shown at 20:58 I see this PM> Add-Migration "InitialCreate" Build started... Build failed. PM>

[@MrMubasit]

Excellent Tutorials . its Simple to understand nice work May God bless you. May we build complete simple website with some basic functionalities using Asp Core.

[@CodAffection]

I will try that with a practical example.

[@vikaswilliam3407]

nice video...will try it soon..

[@muralidharan4437]

thanks for the Awesome Tutorial

[@MauroBernal]

Hi. You are best!! One question: I usually have the result of the entity framework in one layer (AppData), then the CRUD in a different layer (Models), and in the controller call the model to perform the actions of the Crud. This allows me to separate the logics, and not give it a function that does not correspond to the controller such as directly calling the context such as to delete the record. In the same way then I can call the model from another controller, which saves me code. Now I see your video, and from experience I see that many programmers put the CRUD in the controller. Wouldn't this be wrong?

[@uwebraun8893]

Beautiful clarity

[@loveyoukrishna2410]

Thanks for such a great video . At 8.00 you have told only code first approach is available for ef core, i think we can use db first approach too.

[@CodAffection]

sorry for that. thanks for watching and commenting the video.

[@Naughty595]

Super explained. Thanks for the great effort! Would like know if the font-awesome has autocomplete & preview in VS 2019 ?

[@muftaract]

One of the bests. Thanks

[@МаксЛеонов-е6ж]

Impressive, very nice.

[@manolisgkoulias8290]

Man your videos are great!

[@ManushaAmal]

Thank you soo much

[@bluerose234]

At 12:39 Can I add 'localhost' as Server ???

[@Pakistaniwheelers]

At 9:41. Alt ctrl what is the third key

[@CodAffection]

It is a snippet 'ctor' for class constructor. then just hit 'Tab'. did I answer your question?

[@daalwada]

Great Explanation sir!

[@chiku017675]

Thanks for the video.

[@himadrisenapu2543]

In Package Manege Console i write update-database+Enter. But my database is not created and this error message is coming. Error Message: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) What will i do now. Please replay me

[@saulgamba1]

You have the services of SQL Server down or stringconnection is wrong

[@starwarriorsZ]

I had this error as well, make sure you have sql server installed and make sure the connection string is correct for the database you're trying to connect to

[@hendroprasetyo930]

same with this problem, i sure SQL Server running n string connection is correct, but still failed

[@SYO1Star]

same here. same error. I cannot continue from here. I think somehting wrong with the connection string "DevConnection": "Server=(local)\\sqlexpress;Database=EmployeeDB;Trusted_Connection=True;MultipleActiveResultSets=True;"

[@SYO1Star]

I had fixed it This is what i did. I downloaded Microsoft SQL Server Management Studio 1. I run it and it by default connect to something called the 'DESKTOP-ROB3NFJ\TEW_SQLEXPRESS' 2. I go to appsettings.json 3. this tutorial tell us to type "ConnectionStrings": { "DevConnection": "Server=(local)sqlexpress;Database=EmployeeDB;Trusted_Connection=True;MultipleActiveResultSets=True;" 4. I change it to "ConnectionStrings": { "DevConnection": "Server=DESKTOP-ROB3NFJ\\TEW_SQLEXPRESS;Database=EmployeeDB;Trusted_Connection=True;MultipleActiveResultSets=True;" and then i did a update-database at package console manager

[@PraveenKumar-ft2kr]

Awesome 👌👌

[@MrWasap.]

in the controller, if i want to create a method to return a filter register. how i can do it? ill try .where(p => p.idOthers == id) id is from parameter.

[@honeesh1]

Thank you so much Again thank you from the depths

[@shubhamkGupta]

Hi, I really appreciate your efforts and love to learn. I request you to please upload some videos using macOS and VS2019 to build an asp.net core or asp.net MVC application. As I am using macOS and there is so much different from windows. I cannot use the MSSQL in macOS. please do the needful... waiting for your positive reply... Thank you in advance!

[@tuck582]

Why no HTTPS when creating the project? Just curious.

[@lukanesek4064]

would also like to know that

[@rayenoueslati8824]

it worked perfectly , thanks a lot

[@gandhisanket16]

This is very usefull example, Can you show me same example with master and details database.

[@notonurnelly]

Hi CodAffection, Thank you for this tutorial everything was going great until Minute 20:58 and I get the following error PM> Add-Migration "InitialCreate" Add-Migration : The term 'Add-Migration' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At line:1 char:1 + Add-Migration "InitialCreate" + ~~~~~~~~~~~~~ + CategoryInfo : ObjectNotFound: (Add-Migration:String) [], CommandNotFoundException + FullyQualifiedErrorId : CommandNotFoundException I am using Visual Studio 2019 - Can Anyone Help??

[@nhemgomia1010]

Get the nuGet package Microsoft.EntityFrameworkCore.Tools

[@mubassiruddinfurqhan187]

@@nhemgomia1010 even after getting that package it shows this way PM> Add-Migration "InitialCreate" Build started... Build failed. PM>

[@sujeewanandhsathasivam5239]

Thank you and all the best!

[@MrMaksuz]

Question: When user click on edit, AddOrEdit action will send employee object to the AddOrEdit view right ? how does AddOrEdit view knows how to insert data in form fields ? also how do we get user id when we first click ? i dont get this asp-route-id="@item.EmployeeId" line... thx upfront

[@MrMaksuz]

how i see it: //Click -> id(tableItemField) -> AddOrEdit -> View(Employee[id] -> AddOrEdit*view -> (use Employee instance ojb) fill data. //Submit -> AddOrEdit*action -> bind data from fields -> to Employee obj -> save... How does controller know when to use AddOrEdit(int) and when to use AddOrEdit(Employee)... ?

[@mappingthedots2784]

Hey, I am getting the below error while running the command "Update-Database" "A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified

[@МаксИльин-в3ф]

Hi, I have a question: is there or will there be an example where only the administrator can edit or delete the created entries, such as in this video? ty

[@securenet2675]

On adding emoloyeeController views with EF.. it shows error ''couldnot load file or assembly Microsoft.bcl.asyncInterfaces "?? Can u please help me out

[@fabiofocking382]

Thank you so much! nice tutorial. well explained !

[@ndabenhlesithole4457]

Evening this video was so insightful thank you very much. I’m working on a school project we’re required to develop a well functioning system. I’ve come across an an error that says “the model item passed into the ViewDataDictionary is of type ‘practiceECD.Program’ but this ViewDataDictionary instance requires a model item of type ‘practiceECD.Models.Program’ Can you please help me solve this error

[@alexpetruco1348]

you Great Man Thank you so much

[@agustinmoragues191]

Great video man! You helped me understand the basics of Injection!!! Is there any exercise book you recommend me for practising?

[@itissahithi]

When I tried creating a asp.net core application, the page where we need to select MVC did not show to me. As an alternative, what can I do?

[@tuck582]

Why not build models, then scaffold with reference to the context, and then migrate/update via that context? Most of what you did in the first 20 minutes is done automatically if that convention is followed. It will build DB, update Db via context, modify appsettings, and I believe it modifies Startup too. Are you trying to avoid automation to better demonstrate dependency injection?

[@CodAffection]

yes I was trying to show what actually happens during DI.

[@tuck582]

@@CodAffection I see, you did a perfect job in that case! Just wanted to make sure. Thank you for publishing your videos. There are not many .Net/Angular experts with good content on KZbin :)

[@ramkumar12344321]

How to implement ADFS SAML Assertion Consumer with Redirct binding in .net core razor pages application? Please help

[@cariyaputta]

Thanks you so much. You're a savior!

[@shalukrishnan5446]

Great job ...Sir can you describe and give example of ViewModel and Repository in MVC core using Database first approach

[@ronaldjohnson4470]

Awesome tutorial, thank you.

[@hakannyildirim]

You are big man Thnaks For all.

[@NevasSridhar]

Thanks for the tutorial it was very helpful. If I need another entity in the same project called "Student" should I create a StudentContext similar to Employee Context?

[@humbertosilvabarros3827]

Best 1080p60 resolution.👍

[@humbertosilvabarros3827]

Thank you very much.

[@zeuz3961]

Any similar tutorial but Database approach first?

[@nirajzambad7142]

Hi Sir, I am very good at Asp.net c#, HTML , SQL Server but now i want to learn Asp.net core. I don't know abcd of MVC and .net core so my question is does it require ASP.NET MVC before starting .NET CORE? If not required, please tell me the process i must follow to learn .Net Core in fast and easy way. I tried to look into your video, tutorials from your website but not getting controller and other few concepts. Please let me know

[@sebastiancadena485]

You can create a simple Hello World console application tha doesn't use MVC pattern. Follow this link: docs.microsoft.com/en-us/dotnet/core/tutorials/with-visual-studio

[@davidwolfhart]

Thank you for your great tutorial.

[@patasmajeris]

Guys, the delete function was run via the get method. Isn’t that very unsafe?

[@derekj500]

Thanks Sir. This video is really helpfull!!!

[@maksimoski]

Can we use the same db as you?

[@prathamk3358]

when I try to connect .net core API to .net core web, I got 502 error connection refused. can you please suggest me.

[@dkyosk7501]

This is a great tutorial, thanks. As a follow up, can you show how to do identity and token-based authentication that may involve web api or just asp.net core identity?

[@CodAffection]

already done that with asp.net web api and angular sign up : kzbin.info/www/bejne/nmmYkHqKa5d-bKM sign in : kzbin.info/www/bejne/m2mlnYiIo5uGfM0 may be I'll do that with asp.net core web api. I'm not sure about the schedule.

[@dkyosk7501]

@@CodAffection thanks, doing it in asp.ner core will be great, the angular 5 approach has a deprecated {Response}.

[@prometec4828]

Dropdownlist in this form will be great. I have many doubt about o dropdonlist in asp net core. Please help us.

[@mettlus]

What about if you have an existing Db

[@THWUFAILUZAMAN]

Hi iam getting the below error after the command 'Update-Database', can u pls someone help me with this issue A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

[@Ginfinite]

Im getting it too did you find any solution?