ASP.NET MVC Data Access in C# – The complete data path from database to display and back

Full courses: https://www.iamtimcorey.com/courses
Source Code: https://leadmagnets.app/?Resource=MVCDataAccess
Patreon: https://patreon.com/IAmTimCorey
Newsletter signup: https://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