How to connect C to SQL the easy way
>> YOUR LINK HERE: ___ http://youtube.com/watch?v=Et2khGnrIqc
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
#############################
