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

Playback starts YouTube’s embedded player (privacy-enhanced mode).

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

1,143,088 views October 26, 2017 1:20:40

Watch on YouTube
ChannelIAmTimCorey

Chapters

Description from the creator

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: DevForge.com/downloads/?code=ConnectingCSharpTo…
To sign up for announcements about new videos and exclusive discounts, fill out this form: signup.iamtimcorey.com/ (your email will be kept safe and you will not be spammed).
SQL training referenced in the video - DevForge.com/p/sql-databases-from-start-to-fini…

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

About this tutorial

IAmTimCorey published this 1:20:40 video tutorial on October 26, 2017. It has been watched 1,143,088 times on YouTube.

Category
Education
Duration
1:20:40
Published
October 26, 2017
Views
1,143,088
Likes
12,471

Tags

Share

This tutorial in other languages