ASP.NET MVC Data Access in C# - The complete data path from database to display and back
Рет қаралды 337,946
Күн бұрынFull courses: www.iamtimcorey.com/courses
Source Code: leadmagnets.app/?Resource=MVC...
Patreon: / iamtimcorey
Newsletter signup: signup.iamtimcorey.com/
Tutorials are excellent at teaching you about a piece of the overall development puzzle but sometimes you want to take a step back and look at the bigger picture. That way you can see where those puzzle pieces you have been collecting fit into place. This video is going to be that bigger picture overview. We are going to build a small demo of an MVC application and its accompanying database. We will set up a form to collect data, capture that data, and put it into our database. We will then get that data back out of our database and display it on another form. The goal is to show the data access process from beginning to end in ASP.NET MVC. This won't be a full application and we won't complete the full process, since we won't be putting this in source control, we won't be deploying this application, and we won't be setting up authentication.
0:00 - Intro
1:13 - Creating ASP .NET Framework app
4:35 - Adding MVC data Model
6:20 - Sign-up form: new MVC Controller action and View with "create" template
12:56 - Signup-form configuration and validation: data Model annotations
23:41 - Crude sign-up form: Html.EditorForModel()
25:27 - Sign-up from code walkthrough
27:53 - Posted data validation: Controller POST action
32:43 - Posted data storage: Database table design
38:15 - Posted data storage: Database connection string
40:00 - Data Model for database
43:39 - Data access with Dapper
52:09 - Data access Business Logic
59:40 - Storing posted data in Database
1:04:39 - Accessing and displaying data from database.
1:12:44 - Summary and concluding remarks
Thanks to Ralfs HBK and Jack Fitzgerald for the chapters breakdown
@formerfatboy90 Жыл бұрын
I'm a junior developer at a large company. I've been trying to build on this very complex QA application for weeks and feel like a fool for not seeing how the pieces are fitting together, connecting DB to backend to frontend, etc. Your deliberate, explicit instructions are helping me to document the MVC process in my own code and on Miro. This video is really helping me for my career. Thanks, Tim.
@IAmTimCorey Жыл бұрын
Thank you!
@vinuhosanagar1 5 жыл бұрын
While it is very evident that your quality of teaching is fabulous, your commitment and consistency in educating community of developers is amazing I know it requires a lot of efforts to produce such long videos with best quality that too consistently. We all appreciate your contribution sir. Hope you be known to whole dot net community. God bless :)
@IAmTimCorey 5 жыл бұрын
I appreciate the kind words.
@raduionita4496 4 жыл бұрын
I can't thank you enough Tim. I have been struggling for over 2 weeks to find how to do this, and you saved me! Thank you very much. Love you! Subscribed.
@IAmTimCorey 4 жыл бұрын
Awesome!
@lukaskarlgerhard Жыл бұрын
I can’t begin to tell you how helpful your videos are, in just over an hour you’ve helped me understand what it’s taken me all week at work to wrap my head around. I have so much of your content bookmarked. Thank you so much Tim
@IAmTimCorey Жыл бұрын
I am glad it was so helpful.
@gff2112 4 жыл бұрын
You're an awesome instructor Tim.
@IAmTimCorey 4 жыл бұрын
Thank you!
@chrismtz2020 3 жыл бұрын
For those of you who are having issues with your database, here's some advice (after 1 week of listening to this video over and over again): -> When you update your DB, make sure to publish it again -> Put your Database and DataLibrary in the same folder as the MVC project to make things easier. -> ConnectionString should be the exact DB that you're using. Make sure you copy and paste it right too. -> Make sure when you call your DB, to tripple check the spelling (ex. dbo.Users not dbo.User) -> Also, you might get errors using a Database named called "dbo.User". If so, either rename it or use "dbo.[User]" to fix your problem. Good luck everyone! Google your mistakes and dont be afraidto try again and again on your project.
@IAmTimCorey 3 жыл бұрын
Thanks for sharing. Great job sticking with it.
@Arrato1977 Жыл бұрын
I watch your tutorials few days in a row now. Speechless, you are the best teacher I ever seen.
@IAmTimCorey Жыл бұрын
Thank you!
@AamerKhawaja 4 жыл бұрын
Hello Tim, this was the best MVC tutorial on youtube hands-down. This comes from someone who's been through tutorial-hell. Excellent job!
@IAmTimCorey 4 жыл бұрын
I am glad it was so helpful.
@jackfitzgerald5735 3 жыл бұрын
0:00 Intro 1:14 Project setup 4:25 Implementing employee sign-up form 12:00 Adding requirements to employee form 23:10 Making a quick form with html.EditorForModel() 25:28 Understanding how the employee form works in SignUp.cshtml 27:54 Handling the employee form in HomeController.cs 32:45 Creating the Employee table 40:00 Creating the EmployeeModel class in DataLibrary 44:00 Using Dapper to interact with the database 52:09 Implementing the EmployeeProcessor class to handle the business logic 59:39 Using the EmployeeProcessor class to store employee data 1:04:22 Displaying employee data by using the EmployeeProcessor class 1:12:44 Ending review
@IAmTimCorey 3 жыл бұрын
That is a great start. I know doing this time stamping is very time consuming but its a HUGE help to many students. If you get thru the rest of the video and capture the main topic timestamps, I will gladly add it to the video. Thank you for making a significant contribution to the community.
@jackfitzgerald5735 3 жыл бұрын
@@IAmTimCorey Thank you Tim, you have given me the motivation to finish this. And thank you for making great content, I just started learning C# and MVC and your videos have helped me out a lot with understanding how this all works.
@aymanmetwally5560 3 жыл бұрын
Thanks .. is there a .Net Core version?
@omniterry 4 жыл бұрын
Getting addicted to watching your videos. Love your voice and how you pay attention to all the little details. Thank you
@IAmTimCorey 4 жыл бұрын
You are most welcome. Thanks for watching.
@fatimaajij428 5 жыл бұрын
Every time when I watch your Tutorials, I find the actual logic how people work in software Companies. Thanks for Amazing videos.
@IAmTimCorey 5 жыл бұрын
You are most welcome. Thanks for watching.
@greendeer2437 2 жыл бұрын
public static int SaveData(string sql, T data) { using (IDbConnection cnn = new SqlConnection(GetConnectionString())) { return cnn.Execute(sql, data); } } Hi, Thanks for the tutorial. I have tried to run the solution like at 1:02:38 but it gives me error on line "return cnn.Execute(sql, data); " saying that there is an Incorrect syntax near 'value'. The break point does not get hit. How can I resolve this?
@neutronstar6739 2 жыл бұрын
For future people, sounds like you miss `s` on the `values` there. Syntax for SQL Insert would be INSERT INTO your_table(column_name) VALUES (column_name_value) So with this in mind, in this case it would be INSERT INTO dbo.Employee(EmployeeId, FirstName, LastName, EmailAddress) VALUES (@EmployeeId, @FirstName, @LastName, @EmailAddress) It's recommended to look into SQL syntax and educate yourself on SQL injection to understand these.
@rokkrdude 3 жыл бұрын
I am having an issue with the LoadEmployees method in the employeeprocessor. my error is inconsistent accessibility and it claims that the return type is less accessible than the method. can you help me?
@James-zr1lu 3 жыл бұрын
@Garrett Sullivan From memory, I had the same problem. It was because the EmployeeModel class in the Models folder in the DataLibrary folder was not set to public.
@orientgamessa1340 3 жыл бұрын
@Garret Sullivan Thanks so much for asking this question! I was experiencing this too! @@James-zr1lu Thanks so much for the answer! helped tremendously!
@IAmTimCorey 3 жыл бұрын
Its great with the community helps each other out. The IAmTimCorey community members are some of the best!
@haramboy6932 3 жыл бұрын
@@James-zr1lu U Mad LAd
@mierLG 3 жыл бұрын
thanks @@James-zr1lu , save me a lot of time
@tccoder3547 Жыл бұрын
This video was great for me, because I had a hard time understanding how MVC design worked. You also helped me understand validation and model binding as it relates to Model state. You rock Tim Corey!
@IAmTimCorey Жыл бұрын
I am glad it was so helpful.
@chiefxtrc 4 жыл бұрын
these kind of overview videos are very necessary and underrated, I hope you keep implementing them
@IAmTimCorey 4 жыл бұрын
Thank you!
@christiandiomangay5107 3 жыл бұрын
Inconsistent Accessibility:return type 'List' it seems there is an error in the class privacy in the buisness logic please help tim ..
@IAmTimCorey 3 жыл бұрын
It sounds like EmployeeModel is not marked as public.
@christiandiomangay5107 3 жыл бұрын
@@IAmTimCorey Wow great! Thanks for the fast response sir Tim (bow)
@immortal7167 3 жыл бұрын
how did you fix this issue ? I have already added the keyword public
@dariogiordani2002 2 жыл бұрын
Hi Tim thank you for your tutorials, fantastic work. I've ran into an exception on final test run at the SqlDataAccess. return ConfigurationManager.ConnectionStrings[connectionName].ConnectionString;... System.NullReferenceException: 'Object reference not set to an instance of an object.' - Hard to diagnose from three lines but do you have any thoughts? Thanks
@Vyrkadian Жыл бұрын
I'm getting the same error, did you fix it?
@kevinbrosnahan2416 4 жыл бұрын
Awesome video! I learned so much more today even having programmed in ASP/VB.NET Web Forms for over 10 years. Your MVC video was incredible as well. Soon I will be adding MVC5 to my resume!
@IAmTimCorey 4 жыл бұрын
Excellent!
@cagataysert1995 5 жыл бұрын
I just want to say how thankful I am for all your videos. I hope you can add more videos related .net. Thank you again Sir.
@IAmTimCorey 5 жыл бұрын
You are most welcome. Thanks for watching.
@James-zr1lu 3 жыл бұрын
I'm getting the error "System.NullReferenceException: 'Object reference not set to an instance of an object.'" @ 11:48. I have copied everything exactly as in the video. I have also run the source code and still get the same problem. My only difference is that I'm using the latest Visual Studio 16.7, .NET Framework 4.7.2. May the problem may lie there? There are others in the comment section that are having the same problem with no solution. Thank you
@James-zr1lu 3 жыл бұрын
Well, if I change return view() to return View(new Models.EmployeeModel()); for ActionResult SignUp() in the HomeController, then that works.
@IAmTimCorey 3 жыл бұрын
I think maybe you created a different form, maybe an Edit form instead of a create. I just recreated this in a new project in Visual Studio 2019 (16.7.2) with .NET Framework 4.7.2 and it worked as I demonstrated in the video.
@James-zr1lu 3 жыл бұрын
@@IAmTimCorey That can't be it because I also tried using the source code that you provided via the download link in the description. We are using the exact same code yet producing different outcomes. At least I have a work around as I provided above.
@christianconder35 3 жыл бұрын
Hi James. I also have been struggling with the exact same issue as you. I have managed to find a solution. I had placed the connection string into the wrong Web.config file. @ 39:14 Check that you have the connection string in the correct Web.config.
@christianconder35 3 жыл бұрын
@@IAmTimCorey Mr Corey, I really enjoyed the tutorial but I did not initially see that there were two Web.config files and I placed the connection string in the Web.config inside the views folder. Just some feedback
@VictorGarcia-si8wy 2 жыл бұрын
I commend you for not even attempting to try to store passwords. I've stored passwords before and I never want to do it again.
@IAmTimCorey 2 жыл бұрын
Agreed.
@bandermaster81 4 жыл бұрын
I enjoyed the tutorial and learned a lot! I like your style of teaching, you explain everything. While others just assume we know things.
@IAmTimCorey 4 жыл бұрын
I'm glad you enjoyed it and that you found it valuable.
@simonjsaunders 5 жыл бұрын
Thank you so much Tim. I'm really looking forward to the Core video that might be in the works. This has been an incredibly timely and helpful video
@IAmTimCorey 5 жыл бұрын
Thank you!
@robmooreproductions7160 4 жыл бұрын
Is anyone else having trouble with the ConfigurationManager thing at around 46:45?
@traktor207 4 жыл бұрын
You can right click on references in the solution explorer and add System.Configuration manually.
@IAmTimCorey 4 жыл бұрын
Yep, TraktorFerguson is correct.
@mohammedal-haifi6037 4 жыл бұрын
@@traktor207 Thanks. worked for me
@alialsaady5 4 жыл бұрын
To be more specific you must do the following: Right-click on References and click on Add Reference. In Assemblies, select System.Configuration and click OK.
@glebfrolov3557 4 жыл бұрын
for me for some reason worked also adding into references System.Configuration.Install
@victorkimura1 2 жыл бұрын
Hi Tim, I receive an error at around 59:15 when entering "LoadEmployees" ( kzfaq.info/get/bejne/mK-ZeNmQxLeyqKs.html ). Visual Studio states Code CS0050. Inconsistent accessibility: return type 'List' is less accessible than method 'EmployeeProcessor.LoadEmployees()'. I'm a beginner in C# coming from a PHP background. I understand the main concepts thanks your gifting in teaching. :) But is anyone having this problem? If so, how do I resolve it as I can't load the page. I followed along every step of the way. Thank you for your help.
@IAmTimCorey 2 жыл бұрын
That message means that you missed adding "public" to one of your properties or classes. My guess is that the List is not set to public. If not that then the EmployeeModel is not set to public.
@victorkimura1 2 жыл бұрын
@@IAmTimCorey , Hi Tim, Thank you for the reply. I'm very grateful and appreciative that you took the time to respond. I'll check when I'm back at work Monday. I think I checked the public settings but I'll check again and perhaps I'll go through the tutorial on my home computer too. I really like your teaching as you encourage others to write the code step-by-step and this is one of the best ways to learn. I pray the blessings from Numbers 6:24-26 upon you and your family: “‘“The Lord bless you and keep you; 25 the Lord make his face shine on you and be gracious to you; 26 the Lord turn his face toward you and give you peace.”’
@webluke 2 жыл бұрын
@@IAmTimCorey Ran into this too. I missed setting the DataLibrary.Model.EmployeeModel class to public. The error VS gives, and the help in the docs is not very useful.
@mamahumen 2 жыл бұрын
Is there any answer to this?
@UltimatePiccolo 2 жыл бұрын
@@mamahumen I had the same problem, I fixed it by going into the "EmployeeModel" class in the "Models" folder, and making the class public. My line 9 now says "public class EmployeeModel" and I no longer have the error.
@vbgSnake 4 жыл бұрын
Love your classes Tim, really good, great depth and not to focused on stuff. Its also easy to have you on monitor2 while i do your class on monitor1 in my studio. Super thanks. BR
@IAmTimCorey 4 жыл бұрын
Glad you like them!
@ejkenny 5 жыл бұрын
Another amazing ah ha tutorial. You have a great way of putting concepts into English and demonstrating with simple code. Thank you !
@IAmTimCorey 5 жыл бұрын
Excellent! I am glad it helped you out.
@BYFav 3 жыл бұрын
Thank you Tim for this great tutorial! I really appreciate the also delivered valuable hints to methodology. This makes your videos first class.
@tomthelestaff-iamtimcorey7597 3 жыл бұрын
Tim's goal is to educate, not just dump information on folks. I'm glad you can appreciate that.
@species-xo4tz 2 жыл бұрын
More then 2 year ago i had to stop developing and begin learning and maintaining solutions build in ssis, stored procedures using functions, triggers the whole lot.. . Recently I’m starting to develop again. Your videos has help me a lot getting back into development, thank you. You’r for sure one of the better trainers i have found, keep up the good work.
@tomthelestaff-iamtimcorey7597 2 жыл бұрын
Welcome back and thanks for looking to Tim for assistance.
@alevsoft 4 жыл бұрын
A deep and warm "Thank you!" from the bottom of my heart! You are my man XD. No, really. Only your lessons made my way through.
@IAmTimCorey 4 жыл бұрын
You are most welcome. I'm glad they were so helpful.
@jinsmp 4 жыл бұрын
I much appreciate you this type of tutorial. Every person can understand and can fast learning. This is a really good tutorial.
@IAmTimCorey 4 жыл бұрын
Glad it was helpful!
@MaddCoder 5 жыл бұрын
Great video Tim. Exactly what I was looking for and straight to the point.
@IAmTimCorey 5 жыл бұрын
Thank you!
@krogilds 5 жыл бұрын
Really useful Tim, thank you. I understand it now (I think). I had an issue, but found it. This is absolutely wonderful. You are doing really great work, and I am supporting you through your Patron page.
@IAmTimCorey 5 жыл бұрын
I appreciate the kind words and the support.
@abdulmudhir4042 4 жыл бұрын
Why Are you such an amazing dude? I am always super excited to watch your videos even before going to bed
@IAmTimCorey 4 жыл бұрын
Glad you like them!
@hamudaanfoune839 4 жыл бұрын
This was awesome. I am new to MVC and been struggling to wrap my head around it, but this has mad it very clear.. Thank you!
@IAmTimCorey 4 жыл бұрын
Awesome!
@pierreplourde 2 жыл бұрын
Very helpful to see the full stack like this, as to how all the pieces fit together.
@IAmTimCorey 2 жыл бұрын
Glad it was helpful!
@DiddleDangle 5 жыл бұрын
I know this doesn't have to do with the content of the video, but I love how you handle the audio in your videos. I feel like I get to the end of your videos and it feels like only 10 minutes have passed while other lecturers drone on for hours and it really feels that way because you can hear a constant buzzing in the background or every spit wad in their mouth. Thank you for creating such cleanly edited and planned out videos. Looking forward to your content always.
@IAmTimCorey 5 жыл бұрын
I am glad you appreciate the audio quality. I do put a lot of effort into it (even though audio editing is not a skill of mine).
@meeradhumne4685 3 жыл бұрын
Nicely demonstrated. Love the way you put it together. Thanks so much for the tutorial!!
@IAmTimCorey 3 жыл бұрын
Glad it was helpful!
@mmuneebajaz 5 жыл бұрын
Big thumbs , one of best channel on youtube i ever found for .Net
@IAmTimCorey 5 жыл бұрын
Thank you!
@Jinkoyolo 2 жыл бұрын
Nailed it Tim. Nice one. Just what I needed, someone who went through data connection without all the automation. You get from me an A++
@IAmTimCorey 2 жыл бұрын
Thanks!
@Jinkoyolo 2 жыл бұрын
@@IAmTimCorey Hey just trying to extend on the content, do I need to create individual save load classes in dataaccess proj. I feel like my program is loading fom multiple forms automatically and getting stuck at dbaccess
@davidramirez3322 5 жыл бұрын
I could manage to confirm what yuo teach us. Really great tuto! everything worked fine for me, and I could learn a lot watching your excelent way to drive all the stuffs and concepts in a very concrect mode. Thnks a lot.
@IAmTimCorey 5 жыл бұрын
You are most welcome. Thanks for watching.
@bigtimecoder2588 4 жыл бұрын
AWESOME FRIGGIN TUTORIALS DUDE . . . YOU EXPLAIN IT SO CLEARLY AND WITH EASY EXAMPLES INSTEAD OF GOING OVER OUR HEADS . . . AND DON'T WASTE ANY TIME BEFORE JUMPING INTO THE CODE. LOVE IT MAN, I WANT TO SIGN UP FOR YOUR COURSES AND MENTORSHIPS STUFF REALLY BAD BUT IM KIND OF POOR RIGHT NOW.
@IAmTimCorey 4 жыл бұрын
I am glad you have found my content so helpful. The good news is that you can learn a ton for free.
@ernandojeanny1393 3 жыл бұрын
Very good guy your explanation of the subject! I was looking for several days without finding an article that showed and commented as well as his video. Congratulations! It helped me a lot to clarify doubts. Muito boa sua explicação do assunto cara! Passei vários dias procurando sem encontrar um artigo que mostrasse e comentasse tão bem quanto seu vídeo. Parabéns! Me ajudou muito a esclarecer dúvidas.
@IAmTimCorey 3 жыл бұрын
I am glad it was so helpful.
@johnreyp.canillo6569 3 жыл бұрын
Ive watch from the start until the End! Your such a good instructor❤️😍😍
@IAmTimCorey 3 жыл бұрын
Thank you so much!!
@madhavmehendale7324 4 жыл бұрын
Strange as it may sound - this video is symphony. I followed each line of code by coding it in parallel in VS2019 - taking time to savour the notes of logic, the melody of the architecture and the rhythm of the underlying logic as the whole application came together like a musical crescendo. Life is good.........!
@IAmTimCorey 4 жыл бұрын
I am glad you found it so pleasing.
@iantrembirth6918 5 жыл бұрын
Tim, I'm starting to make the move from web forms to MVC for a pretty big project and have read a couple of books and seen a few video tutorials (including one on Channel 9), this is the clearest explanation yet of how MVC works and how to actually get it to do something. Thank you!
@IAmTimCorey 5 жыл бұрын
I appreciate the kind words. I'm glad you found it clear and helpful.
@tomsupis8724 3 жыл бұрын
Thanks, Tim, was a great video, def better than my last coach. Had multiple errors, but I handled them like a champ, and the comment section helped a lot. Looks like its better if I learn some SQL before I continue with ASP.net
@IAmTimCorey 3 жыл бұрын
I'm glad it was helpful.
@benja-min1588 4 жыл бұрын
Found this video immensely useful in 2020. Great Job, take my sub and gratitude!
@IAmTimCorey 4 жыл бұрын
Glad it helped!
@khanhzodoi 4 жыл бұрын
So many things to learn in just a video. Thank you very much!!!
@IAmTimCorey 4 жыл бұрын
You are welcome.
@nuthouse99 5 жыл бұрын
Outstanding video - easy to understand gives a usable example from which to build.
@IAmTimCorey 5 жыл бұрын
Thank you!
@mariustaboo 5 жыл бұрын
Nice one! Another great mini tutorial from Tim Corey.
@IAmTimCorey 5 жыл бұрын
Thank you!
@TAPE5IVE 4 жыл бұрын
Great tutorial. Very helpful for my .NET module as part of BSc Computer Science Honours degree. Thank you 🤙🏼
@IAmTimCorey 4 жыл бұрын
I am glad it has been so helpful.
@Motuochez 5 жыл бұрын
Great video! I did miss a lot of logic of the methods and the classes and didn't really understand what does what exactly but just like you intended, this video is great for understanding the whole process and the bigger picture!
@IAmTimCorey 5 жыл бұрын
Thanks!
@hawnyawk1 5 жыл бұрын
Thanks for the video Tim, I recently got a VB6 to Web project dumped on me, being mostly a desktop programmer I was lost on what to do. This video made it clear that MVC was the way to go. Thanks so much.
@IAmTimCorey 5 жыл бұрын
You are most welcome. Thanks for watching.
@rudreshangadi4496 5 жыл бұрын
One more fruitful productive morning .. Excellent dear Mr. Tim.. Very clear, neat and upto the mark.. I am getting confidence to work on my entity framework web application that is going to start right from tomorrow :-)
@IAmTimCorey 5 жыл бұрын
I am glad it was so helpful.
@samuelowoyemi 3 жыл бұрын
This is a great tutorial. Easy to follow and implement. Thank you so much!
@tomthelestaff-iamtimcorey7597 3 жыл бұрын
Thanks for watching!
@dperfetto89 Жыл бұрын
This video was helpful and at a good digestible pace. Thanks!
@IAmTimCorey Жыл бұрын
You are welcome.
@albasula216 4 жыл бұрын
I loved the vid ... i bought a udemy course for this and it was terrible... the teacher was saying this is beyond the scope of this course but u can find it in my other udemy course...and that happended multiple times...it was really hard to understand what he was doing...and not even close to this way of coding...thank u so much for your great work ....I actually have a task to complete in order to get a job as .Net dev and this helped a lot...thank u so much...I will consider buying one of ur courses but when I get the job...bc a bit expensive ...but it is worth it bc of the great material and great way of teaching...again thank u and u won a new subs and supporter 😊
@IAmTimCorey 4 жыл бұрын
I'm glad this video was so helpful.
@lukehewitt604 4 жыл бұрын
Thank you for the very clear tutorial Tim! It helped me understand a lot!
@IAmTimCorey 4 жыл бұрын
Glad it helped!
@chengfeng6375 5 жыл бұрын
It's the best one I have never seen, thanks Tim.
@IAmTimCorey 5 жыл бұрын
You are most welcome. Thanks for watching.
@kennington4375 4 жыл бұрын
Would love to see more ASP.NET. Your doing such a great job. It's much clearer and better than courses in University.
@IAmTimCorey 4 жыл бұрын
More to come!
@kennington4375 4 жыл бұрын
@@IAmTimCorey Sending emails and using Webforms would be great :)
@mokatemoreki8620 4 жыл бұрын
Indeed this is much better than in University, worst in university such topics of MVC are not covered we only do C# and Desktop Apps if we are lucky
@oskar5700 2 жыл бұрын
Amazing videos. You made this easily understandable and explained it clearly. Keep up the good videos! :D
@IAmTimCorey 2 жыл бұрын
Thank you.
@SirHonore 5 жыл бұрын
Hi Tim, thank you for another great video.
@IAmTimCorey 5 жыл бұрын
You are most welcome. Thanks for watching.
@nickeax 4 жыл бұрын
This is a fantastic guide, like all of your videos. Many thanks.
@IAmTimCorey 4 жыл бұрын
You are welcome.
@philippeanglard7394 2 жыл бұрын
Thank you for your tuto! English/American isn't my native langage, but I hink I was understanding you at 95%.
@IAmTimCorey 2 жыл бұрын
Awesome!
@rajnhard 5 жыл бұрын
Good video Tim, thanks. It`s also worth mentioning, that the Id of the Employee table (PK), supposed to be set IsIdentity to yes and also enable identity increment ( mine was defaultly set to false ).
@IAmTimCorey 5 жыл бұрын
I didn't point it out (and I should have) but at 33:58, I add "IDENTITY" at the end of the ID column. That sets it up to be an identity column with an auto-increment value of (1,1).
@geezer2450 5 жыл бұрын
Thank you Tim - exactly what I needed!
@IAmTimCorey 5 жыл бұрын
You are welcome.
@joshuatindoc1013 3 жыл бұрын
Very informative Demo Thank you. You're a great influencer God bless you
@IAmTimCorey 3 жыл бұрын
Thank you!
@sunainaarora975 5 жыл бұрын
Nicely Explained. Great Video! Thanks Tim.
@IAmTimCorey 5 жыл бұрын
Thank you!
@rizreighnand6471 5 жыл бұрын
great explaination! i saw asp.net as a complicated framework but you explained it very well subbed!
@IAmTimCorey 5 жыл бұрын
I appreciate the kind words.
@jean-francoispedneault3632 2 жыл бұрын
This is awsome! Crystal clear! Thank you so much!
@IAmTimCorey 2 жыл бұрын
You're so welcome!
@waz_boolin6582 5 жыл бұрын
Dude you are a lifesaver thanks for the valuable info.
@IAmTimCorey 5 жыл бұрын
You are welcome.
@aritralahiri8321 Жыл бұрын
Very Informative and beautifully explained video. Thanks a lot for this.
@IAmTimCorey Жыл бұрын
You are welcome.
@Ahmad_Hamdy_Hamdeen Жыл бұрын
A lot of thanks, Tim Corey 🙏
@IAmTimCorey Жыл бұрын
You are welcome.
@jason59130 4 жыл бұрын
This video has helped me a lot. You re amazing. Thank you 😍
@IAmTimCorey 4 жыл бұрын
You are welcome.
@hthclash1970 5 жыл бұрын
Super clean code, I love it.
@IAmTimCorey 5 жыл бұрын
Thanks!
@fsfehico 4 жыл бұрын
Great video Tim. Thank you
@IAmTimCorey 4 жыл бұрын
You are welcome.
@ThistleBlue 4 жыл бұрын
Thanks for the help with this code, very helpful in providing ideas of how to do things for my University course. Just need to implement Update and Delete now.
@IAmTimCorey 4 жыл бұрын
Excellent!
@victorf.6469 3 жыл бұрын
Really helpful tips and simple teaching.
@IAmTimCorey 3 жыл бұрын
Thanks!
@andrewpeterson4219 5 жыл бұрын
You a hero Tim! Also, a course on making a blog engine would be cool.
@IAmTimCorey 5 жыл бұрын
Thanks for the suggestion!
@Dotto19 4 жыл бұрын
Hi Tim, This is very useful. Thank you
@IAmTimCorey 4 жыл бұрын
You are welcome.
@coleanderson8242 2 жыл бұрын
Perfect tutorial! Keep it up!
@IAmTimCorey 2 жыл бұрын
Thanks!
@audiofrank6747 2 жыл бұрын
Thank you so much for this great content !
@IAmTimCorey 2 жыл бұрын
You are welcome.
@francescacedro3501 5 жыл бұрын
thank you! you're the best "teacher"!
@IAmTimCorey 5 жыл бұрын
You are most welcome. Thanks for watching.
@maciejszczepkowski9548 4 жыл бұрын
Really good and interesting tutorial. Thanks for it.
@IAmTimCorey 4 жыл бұрын
You are welcome
@rafaelrodriguessilva9994 5 ай бұрын
and as always, excellence!
@IAmTimCorey 5 ай бұрын
Thank you!
@RudiHansen 5 жыл бұрын
Great video as always thanks. But a little late :-) I just finished my first MVC app for a client today using your old video (Introduction to ASP.NET MVC) and some Google Foo, i think this video would have saved me about one day of work :-) Now instead I have some refactoring to do....
@IAmTimCorey 5 жыл бұрын
Bummer. Sorry it didn't come out a bit quicker. Maybe next time.
@antonlyamin3318 4 жыл бұрын
Tim your channel is an absolute goldmine of programming knowledge. It amazes me how well you relate all your coding to the higher level programming concepts you aim to explain. I have used your MVC videos to introduce myself to the field of web development. Because of you I am confident in creating a simple website using MVC and am now looking to expand my horizons. However I have encountered an problem. There seems to be so many directions to go from here, and I'm struggling to figure out which are most relevant and useful to me. My question to you is, for someone interesting in web development, who has a solid understanding of OO principles, SQL and front end design langauges (css, javascript, html) yet has only started to combine them using platforms like MVC, what are the next steps to take?
@IAmTimCorey 4 жыл бұрын
I would look at .NET Core, and specifically Razor Pages (here is a video: kzfaq.info/get/bejne/bJ6kotqivsm1nI0.html ). Then, start practicing. Build test projects and learn how the pieces fit together.
@peterzhou3366 4 жыл бұрын
Thanks for sharing this video!
@IAmTimCorey 4 жыл бұрын
You are welcome.
@OmniTato 3 жыл бұрын
For those struggling with an error saying "System.NullReferenceException: Object reference not set to an instance of an object", check that your connection string is in the CORRECT web.config file. It SHOULD be in the Web.config below packages.config and Global.asax in your MVCApp project, NOT the one under views, shared, Web.config. This solved my problem =) Hope this helps those who are struggling, because I sure as hell nearly pulled my hair out hahaha
@tomthelestaff-iamtimcorey7597 3 жыл бұрын
Thank you for sharing this. I'm sure it will help others.
@lucasisaac8063 3 жыл бұрын
Mine was already in the correct web.config folder, but thank you for the advice. Tim said in another comment, that a class or a variable needs to be instantiated. I copied his code line for line (Or so I thought) and I still can't find it... Again, thank you for the advice
@ulviugur3605 3 жыл бұрын
Thanks Tim ! Using the same class name for both business and view was a tricky one. I am not sure how that is sorted without using fully qualified name of the classes. Cheers
@agusd3327 3 жыл бұрын
Thank you very much Tim, it was really helpfull!
@tomthelestaff-iamtimcorey7597 3 жыл бұрын
Thank you for learning with Tim.
@haseenap3592 3 жыл бұрын
Thank you for this video. Very helpful
@IAmTimCorey 3 жыл бұрын
You are welcome!
@yogevgershon3424 4 жыл бұрын
37:14 Dear Tim, I love your videos! it helped me a lot to improve myself (4 year programmer), you said as a rule dont use password as plain text into you db, which I fully aggree, but you just explaind why not to do it, and not how to do it correctly (with somekind of guid or hashing) Would really love of you to make a video of authantication on MVC.
@IAmTimCorey 4 жыл бұрын
Use a system like Microsoft Identity (I use it in the TimCo Retail Manager series and a couple other videos). The big thing is to not design your own system.
@brendonanderson8673 4 жыл бұрын
Thank you Tim!
@IAmTimCorey 4 жыл бұрын
You are welcome.
@mrpoeky2527 4 жыл бұрын
Thank you for making this video :)
@IAmTimCorey 4 жыл бұрын
You are welcome.
@alexcretan7152 3 жыл бұрын
Awesome video Tim. You have an unique and amazing way of explaining things. I watched most of your .net core/framework videos and want to learn more from you. Is there any other videos of your work that you can provide me (maybe a link to your website or something...i dont know haha). Thank you very much for your work!
@IAmTimCorey 3 жыл бұрын
I do sell courses at IAmTimCorey.com (there are over 20 there with more coming soon).
@worlukk 3 жыл бұрын
good video. i followed along and recreated the application sans the plural error on the employee(s) table
@IAmTimCorey 3 жыл бұрын
Thanks, glad to hear it
@danielcory4187 4 жыл бұрын
Once again, my favorite KZfaqr! I am working on a Blog Site for fun, so this is very helpful. I do have two questions though: 1. You mentioned to never store passwords in the database....Are you just saying not to do in in clear text or at all? I understand it would need to be hashed and salted and encrypted, etc., is it okay to do after that has been done properly? 2. At what point did Dapper come into play? Which functions/classes were you using that required Dapper?
@IAmTimCorey 4 жыл бұрын
Never in clear text and I highly discourage people from rolling their own security. Use a system for that. Otherwise it makes your app too vulnerable. As for Dapper, it is used to talk to SQL.
IAmTimCorey
Рет қаралды 181 М.
AnythingAlexia
Рет қаралды 30 МЛН
IAmTimCorey
Рет қаралды 815 М.
IAmTimCorey
Рет қаралды 860 М.
IAmTimCorey
Рет қаралды 447 М.
IAmTimCorey
Рет қаралды 438 М.
Programming with Mosh
Рет қаралды 868 М.
IAmTimCorey
Рет қаралды 255 М.
IAmTimCorey
Рет қаралды 299 М.