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
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.
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
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!
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.
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
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!
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?
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
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?
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
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!
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
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
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
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?
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.
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
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.
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!
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.
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 :)
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.
Can you please show us how to make user authentication after we already have a database? So how to populate a User table in an existing DbContext, using the authentication mechanism, pleasee!
Can you please do a tutorial on how to do a similar application, but also with deploying it to Azure? I am stuck on how to take database + CRUD app and move it into Azure so it can be viewed online.
Good Tutorial. I was wondering what is the difference between using Asp.Net Core and using Angular as your UI or front end? Also could you do a tutorial using Blazor, I know it is not mature for production. Thanks !
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
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)... ?
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
On adding emoloyeeController views with EF.. it shows error ''couldnot load file or assembly Microsoft.bcl.asyncInterfaces "?? Can u please help me out
@@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
@CodAffection your tutorial is very good, may i know how long you mastered angular, mvc .netcore or any web development? I'm a newbie programmer, therefore sometime i'm doubt myself if i could be mastered web development like you
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 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 UA-cam :)
Very nice video, I tried to perform with .net core 3.1, but when I am trying to add Controller with view in same manner in video its throwing an error "There was an error running the selected code generator:'package restore failed.Rolling back package changes for 'ProjectName' " can anyone help for this??
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?
already done that with asp.net web api and angular sign up : ua-cam.com/video/h85_GT62K6A/v-deo.html sign in : ua-cam.com/video/e8BlURn6SFk/v-deo.html may be I'll do that with asp.net core web api. I'm not sure about the schedule.
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>
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
Can you please show us how to make and use Data Transfer Objects and actually explain them how they work?
Greetings from Macedonia!
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.
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
Your accent is very clear sir, good job. And you explain nicely
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!
Thanks for the wonderful feedback.
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.
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
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!
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?
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
ASP.NET Core MVC and ASP.NET Core Razor are the same? Can I only learning ASP.NET Core MVC?
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?
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
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!
Glad I could help!
Thanks for your wonderful feedback.
Thanks a lot . we need more in .net core and angular
sure. I'm working on it.
@@CodAffection I'm waiting for it
@@ShivamSingh-wh9jj don't you get the notification about my yesterday video - angular inline table editing
@@CodAffection Oh sorry 😅
This tutorial is awesome .... please record full .net core tutorial session .. Thanks a lot for this tutorial
Glad you found the tutorial helpful.
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
Super explained. Thanks for the great effort!
Would like know if the font-awesome has autocomplete & preview in VS 2019 ?
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.
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
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
Please keep making videos, This helps a lot. Thank you
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
I think no need, it was already installed for me
thank you so much sir, this is an awesome tutorial on .net core
thanks! sir for the awesome very useful video on asp.net ef core, very clear and immaculate presentation
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?
This man is marvelous.
Hey I think the create database part, you jump into the "microsoft SQL Server Management Studio" without showing how you actually connect to that?
He covered how to connect to SQL server near the beginning of the video around the 12 min mark
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.
thanks for your wonderful feedback.
Awesome tutorial thank you , can you publish Asp.Net Core MVC Web App CRUD with EF Core
and modal bootstrap ??
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
Dropdownlist in this form will be great. I have many doubt about o dropdonlist in asp net core. Please help us.
Beautiful clarity
Thankyou so much, one of the best tutorial out there.
Glad you think so!
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.
sorry for that. thanks for watching and commenting the video.
Wonderful explanation. Thank you
ASP.NET or ASP.NET Core which is best? Why?
One of the bests. Thanks
Can we use the same db as you?
Guys, the delete function was run via the get method. Isn’t that very unsafe?
very helpful video. clear to understand.
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.
Thank you so much for the good tutorial! Keep up the awesome work
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!
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.
Great video man! You helped me understand the basics of Injection!!! Is there any exercise book you recommend me for practising?
Nice tutorial. I want to ask something. I have a lot of fields and I want to move the table so close to left side. How possible is??? Thanks btw.
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 :)
Good explaination thank you
Impressive, very nice.
AddorEdit function is really useful.
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?
Can you share video haw to create USER with permission roles
Did you found help?
You have one example?
What about if you have an existing Db
Really Helpful thank you very much for this clear explanation, hope for more videos
Why no HTTPS when creating the project? Just curious.
would also like to know that
Excellent! You helped me to begin work with this framework. Thank you!!!!
thanks for the comment. glad you found it helpful.
Any similar tutorial but Database approach first?
Thank you so much for this video. it's awesome for MVC beginners.
glad you found the video helpful.
great video. I created my first project so easily..
Keep it up
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.
I will try that with a practical example.
Can you please show us how to make user authentication after we already have a database? So how to populate a User table in an existing DbContext, using the authentication mechanism, pleasee!
Can you please do a tutorial on how to do a similar application, but also with deploying it to Azure? I am stuck on how to take database + CRUD app and move it into Azure so it can be viewed online.
Thank you soo much
Thanks for the video.
thanks for the Awesome Tutorial
Good Tutorial. I was wondering what is the difference between using Asp.Net Core and using Angular as your UI or front end? Also could you do a tutorial using Blazor, I know it is not mature for production. Thanks !
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
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)... ?
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
Real nice mate! I appreciate your videos a lot!
Thank you and all the best!
On adding emoloyeeController views with EF.. it shows error ''couldnot load file or assembly Microsoft.bcl.asyncInterfaces "?? Can u please help me out
Thanks a lot, well explained and very wasy to understand. Im now subscribed and hope you upload some more ASP.NET Core tutorials.
Sure.
Thank you so much we want more content with this quality
sure.
@@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
Very NICE tutorial. Thanks a lot.
Glad you found the video helpful.
@CodAffection your tutorial is very good, may i know how long you mastered angular, mvc .netcore or any web development? I'm a newbie programmer, therefore sometime i'm doubt myself if i could be mastered web development like you
I think for past 3 years.
thanks for the wonderful feedback!
thank you so much, good and simple and straight forward tutorial
thanks for the comment .let me know if you have any video suggestion in asp.net core.
I love all of your tutorials, You Have a great Work, Thank You
Glad you like them!
This is very usefull example, Can you show me same example with master and details database.
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?
yes I was trying to show what actually happens during DI.
@@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 UA-cam :)
Man your videos are great!
I had a issue in icons its not displaying .....
Simply explained. Appreciate your effort. Thanks!
Brilliant Good Going bro...learned a lot thanks.......
nice video...will try it soon..
Great Explanation sir!
Great job ...Sir can you describe and give example of ViewModel and Repository in MVC core using Database first approach
شكراً جزيلاً
At 12:39 Can I add 'localhost' as Server ???
How to implement ADFS SAML Assertion Consumer with Redirct binding in .net core razor pages application? Please help
Very nice video, I tried to perform with .net core 3.1, but when I am trying to add Controller with view in same manner in video its throwing an error "There was an error running the selected code generator:'package restore failed.Rolling back package changes for 'ProjectName' " can anyone help for this??
you Great Man Thank you so much
it worked perfectly , thanks a lot
Thank you so much
Again thank you from the depths
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?
already done that with asp.net web api and angular
sign up : ua-cam.com/video/h85_GT62K6A/v-deo.html
sign in : ua-cam.com/video/e8BlURn6SFk/v-deo.html
may be I'll do that with asp.net core web api. I'm not sure about the schedule.
@@CodAffection thanks, doing it in asp.ner core will be great, the angular 5 approach has a deprecated {Response}.
Thanks you so much. You're a savior!
Watchout on 19:37. I think it is an edition mistake. The 'TypeName' suddenly disappears. Must go on each attribute.
Thank you very much CodAffection, you have been a huge help!
video is good, but why you don't use dropdown list checkbox list radio button list plz use all those HTML controls and make CRUD Operation
You are big man Thnaks For all.
Thank you for your great tutorial.
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>