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.
Source Code:
To sign up for announcements about new videos and exclusive discounts, fill out this form: (your email will be kept safe and you will not be spammed).
SQL training referenced in the video -
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
Watch video How to connect C# to SQL (the easy way) online without registration, duration 01 hours 20 minute 40 second in high hd quality. This video was added by user IAmTimCorey 28 February 2017, don't forget to share it with your friends and acquaintances, it has been viewed on our site 1 million once and liked it 12 thousand people.