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: https://leadmagnets.app/?Resource=ConnectingCSharpToSQL
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).
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
Видео How to connect C# to SQL (the easy way) канала IAmTimCorey
Source Code: https://leadmagnets.app/?Resource=ConnectingCSharpToSQL
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).
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
Видео How to connect C# to SQL (the easy way) канала IAmTimCorey
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Creating a C# Application: From idea to finished productEntity Framework Best Practices - Should EFCore Be Your Data Access of Choice?Create Login Window in C# Using Sql ServerMySQL Tutorial for Beginners [Full Course]WinForm vs WPF vs UWP vs Console - The C# Desktop UI Showdown (and the future with .NET 5)SQL Stored Procedures - What They Are, Best Practices, Security, and More...ASP.NET MVC Data Access in C# - The complete data path from database to display and backIntroduction to ASP.NET MVC in C#: Basics, Advanced Topics, Tips, Tricks, Best Practices, and MoreBetter Object Mapping in .NET with Dapper by Kevin GriffinTop 10 C# Best Practices (plus bonuses).NET Core 3.1 MVC REST API - Full CourseC# Database Programming for Beginners | Part 1 - Creating a SQL Server DatabaseConnecting C# To MySQL Using Blazor (Full CRUD Actions)Git Tutorial for Beginners: A Quick Start GuideDelegates in C# - A practical demonstration, including Action and FuncIntro to WPF: Learn the basics and best practices of WPF for C#C# Generics - What they are, why they are useful, and how to create themHow to connect SQL server database with visual Studio C#Advanced Dapper in C# - SQL Transactions, Mulitple DataSets, UDTs, and more