How to connect C# to SQL (the easy way)
IAmTimCorey IAmTimCorey
411K subscribers
1,088,559 views
0

 Published On Feb 28, 2017

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: https://leadmagnets.app/?Resource=Con...
To sign up for announcements about new videos and exclusive discounts, fill out this form: https://signup.iamtimcorey.com/ (your email will be kept safe and you will not be spammed).
SQL training referenced in the video - https://iamtimcorey.com/p/sql-databas...

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

show more

Share/Embed