How to connect C# to SQL (the easy way)

Learn how to connect to SQL from C# the easy way, using a micro-ORM called Dapper (built by the Stack Overflow team). See how easy it is to get data in and out of SQL without complicated generated code or messy DataTables.

Timestamps contributed by: Ralfs HBK
0:00 - Intro
0:34 - Data base connection options: ADO, Entity Framework, Dapper
4:53 - Creating Demo Application: Win Forms
6:38 - Demo Database and Data Model
11:23 - Connection string: helper class
14:58 - Adding connection string
19:45 - Using connection string with helper class
22:25 - Recap
22:40 - Creating a UI form for displaying the data
25:24 - Wiring up the UI form: C# code design
30:24 - Wiring up the UI form: list box info
33:57 - Wiring up the UI form: data access from data base with Dapper
43:47 - Wiring up the UI form: debugging and list box bindings
50:05 - Wiring up the UI form: recap and notes on good practice for data access
51:57 - Stored procedures
58:05 - Explaining demo code so far
1:02:46 - Storing in data base: UI form design and wiring
1:08:26 - Storing in data base: C# code
1:15:08 - Storing in data base: Recap
1:16:04 - Summary and concluding remarks

[MS-ellp]

I'm gonna be honest here. You have the best format of transferring coding knowledge I've ever experienced. The way you simple things down, explain why you do everything, your clear/calm sounding voice, even the little 'pro tips' you throw in every video like explaining 'tab+tab' shortcuts, explaining what a "ThrowNewException()" does... Also, if I'm stuck with something in your videos you somehow magically know what I need to learn to understand the next step and refer me to one of you other videos that teach me things I need for the next step. I honestly can say I learned more in 2 weeks of watching your videos daily than several months at college. They just teach you stuff without really explaining the "why" behind it, so you end up googling it for yourself and spend a ton of time. Thanks for the free knowledge and keep up the good work!

[eitzhadas]

You have no idea how much this video has helped me, not only with data access but with objects in general. Thank you so much!

[andylowe]

awesome ... don't ever underestimate the way you communicate your learning, it is really powerful and comprehensive ... top job Tim

[GreatFilmsPH]

You're a God sent to students like me. I'm working on a School project and this may just be what I needed exactly. Thank you so much good sir. I've watched the whole thing.

[jwilson]

Great step by step tutorial with extremely good presentation and explanations.
Helped a 63 year old 'newbie' to a much better understanding of C#.

[rjnx]

This is the best tutorial I have ever watched, seriously. I really feel like you are sitting right next to me explaining everything, even the things I know, but that just makes it better. Good stuff brother. Really good stuff.

[huzaifatinwala]

Learned more in this one hour video than I did watching tons of videos and articles.
Best 60 mins ever spent. Thanks Tim.

[marcinburak]

Thank you so much Tim! I always wanted to make more complex apps that would remember data from earlier sessions. I tried many ways to achieve it, but all of them failed somehow - it was just too complex.
Then you came to my rescue and made everything look so easy.
Thank you once again.

[roydrechsel]

Dude, I've watched a lot of tutorials, and you're among the (if not THE) best I've seen. Very thorough, organized, efficient, and clear. Thank you for these, really great work!

[RalfsBalodis]

0:00 - Intro
0:34 - Data base connection options: ADO, Entity Framework, Dapper
4:53 - Creating Demo Application: Win Forms
6:38 - Demo Database and Data Model
11:23 - Connection string: helper class
14:58 - Adding connection string
19:45 - Using connection string with helper class
22:25 - Recap
22:40 - Creating a UI form for displaying the data
25:24 - Wiring up the UI form: C# code design
30:24 - Wiring up the UI form: list box info
33:57 - Wiring up the UI form: data access from data base with Dapper
43:47 - Wiring up the UI form: debugging and list box bindings
50:05 - Wiring up the UI form: recap and notes on good practice for data access
51:57 - Stored procedures
58:05 - Explaining demo code so far
1:02:46 - Storing in data base: UI form design and wiring
1:08:26 - Storing in data base: C# code
1:15:08 - Storing in data base: Recap
1:16:04 - Summary and concluding remarks

Welcome to "C# Data Access" playlist.

[colin-campbell]

We don't deserve a content creator like you.

Thanks for everything you've taught us so far!

[vectieba]

Thanks for the videos, your explanations and tutoring are really very thorough and informative. I know how much work it is to make these and appreciate the time and effort you put aside for doing this.

[troythompson]

This might be the most perfectly paced long form tutorial I've seen

[DarkNightSonata]

this is awesome, literally over the top explanation. I cant thank you enough. i'm getting into database now, and this was extremely helpful. i already subscribed to you and will checkout your lessons. youtube is full of bad instructors and it is a bless to find people like you as it is very rare. in the past month I started learning MVVM, WPF and xaml and now sql with dapper. it is fun yet very challenging. hopefully it'll be rewarding. i'll surely watch and check most of your lessons regarding databases.

[OrgasmicOrgami]

The most comprehensive video I've seen on this subject matter. Thank you so much for the video and your help Tim!

[mahtabselect]

Loved it, very straightforward and easy to understand. You have no idea how much this video has helped me, not only with data access but with objects in general. Thank you so much!

[FaultyProgeny]

Others have said it, I just want to reaffirm it, your teaching style is absolutely exceptional. I am greatly appreciative to have come across your video's, this video and another on building a SQL Database have helped me tremendously with a project I'm currently working on.

I'll be checking out some of your paid courses in the future as I need, I feel confident I'll get every penny's worth after learning from these well paced, well thought out, thorough but not overloading, free tutorials.

Thank you for sharing your knowledge in such a clear and comprehensive way! 👏

[shawnmofid]

Thank you so much for the great content. I am progressing very quickly, and enjoy using my skills and watching the results.

[jimrodda]

I recommend Tim's intro to SQL course on his website; I watched this C# to SQL video, then took the course. When I came back to watch a second time, I understood the C# content on a much deeper level. Thanks Tim!

[pickwick]

Great tutorial! I used to work with Access and VB and I'm switching to SQL / C#. This video was very helpful. Just like your other video's the video and audio quality is perfect and your explanation is very clear! Good job!