Implementing ADO.NET 4 with C# 8

Focused View

Paul D. Sheriff

2:28:04

17 View

00. Course Overview

00. Course Overview.mp4

01:33

01. Why You Still Need to Know ADO.NET

00. Introduction and Assumptions.mp4

01:28

01. Modules in this Course.mp4

02:01

02. Why ADO.NET Still Matters.mp4

00:46

03. The Classes of ADO.NET.mp4

02:31

04. ORMs and ADO.NET.mp4

02:53

05. Demo of Sample Code from this Course.mp4

04:28

06. Module summary.mp4

00:44

02. Connecting and Submitting Queries to a Database

00. Module Introduction.mp4

00:29

01. The Connection Class.mp4

01:10

02. Opening a Connection.mp4

03:04

03. Employ a Using Block.mp4

00:48

04. Catching Connection Exceptions.mp4

01:40

05. Using ConnectionStrings.com.mp4

01:16

06. Retrieving a Scalar Value using a Command Object.mp4

02:18

07. Submit an INSERT Statement using ExecuteNonQuery.mp4

02:01

08. Submit a Query with Parameters.mp4

03:32

09. Submit an INSERT Statement with Parameters.mp4

01:41

10. Using OUTPUT Parameters.mp4

03:37

11. Transaction Processing.mp4

03:37

12. Module Summary.mp4

00:46

03. Retrieve Data Quickly Using the SqlDataReader

00. Introduction to DataReaders.mp4

00:53

01. Processing Rows in a DataReader.mp4

02:56

02. The DataReader Methods GetOrdinal, GetInt32, and Others.mp4

03:08

03. Demo of DataReader Methods.mp4

03:14

04. Using the GetFieldValue Method.mp4

01:49

05. Create Extension Method to Handle Nulls.mp4

02:49

06. Multiple Result Sets.mp4

02:47

07. Module Summary.mp4

00:50

04. Handling ADO.NET Exceptions

00. Introduction to Exception Handling.mp4

01:01

01. Simple Exception Handling.mp4

02:12

02. Catching a SqlException to Gather More Information.mp4

04:17

03. How to Create a SqlExceptionManager Class.mp4

03:15

04. Demo of SqlExceptionManager Class.mp4

03:45

05. Walk Through of the SqlExceptionManager Class.mp4

07:09

06. Module Summary.mp4

00:48

05. Disconnected Classes Are Useful

00. What are Disconnected Classes - .mp4

00:57

01. Loading a DataTable Using a SqlDataAdapter.mp4

04:33

02. Create a Generic List of Products from a DataTable.mp4

03:13

03. Multiple Result Sets and the DataSet Class.mp4

02:15

04. Using a DataView for Sorting.mp4

03:21

05. Filtering Data Using a DataView.mp4

01:33

06. Create a DataView using a LINQ statement.mp4

01:33

07. Convert a DataView Back to a DataTable.mp4

01:20

08. Module Summary.mp4

00:40

06. The Building Blocks of the DataTable

00. Module Introduction.mp4

00:32

01. Create a DataTable using C#.mp4

03:35

02. Cloning and Copying DataTables.mp4

02:08

03. Using Select Method to Filter Rows.mp4

03:19

04. The CopyToDataTable Method.mp4

01:35

05. Module Summary.mp4

00:41

07. Builder Classes Make It Easy to Work with ADO.NET

00. Introduction to SqlConnectionStringBuilder.mp4

00:32

01. Break Apart a Connection String.mp4

02:17

02. Create a Connection String Using SqlConnectionStringBuilder.mp4

01:32

03. Using the SqlCommandBuilder.mp4

02:33

04. Inserting a Product using the SqlCommandBuilder.mp4

02:25

05. Module Summary.mp4

00:51

08. Making ADO.NET Easy to Use

00. Overview of the ADO.NET Wrapper Classes.mp4

02:23

01. Diving into the Main ADO.NET Wrapper Classes.mp4

04:54

02. Retrieve Data Using Just a Few Lines of Code.mp4

03:05

03. Using Parameters to Search for Data.mp4

02:52

04. Retrieve Data Using a Stored Procedure.mp4

02:02

05. Getting Multiple Result Sets.mp4

02:09

06. Modifying Data.mp4

03:06

07. Transaction Processing.mp4

01:45

08. Module and Course Summary.mp4

01:07

Description

Learn the most efficient method to access data in your SQL database using ADO.NET. Learn to simplify ADO.NET to just a few lines of code.

What You'll Learn?

In this course, Implementing ADO.NET 4 with C# 8, you find out why ADO.NET is still relevant in today's ORM world. First you learn how to connect and submit queries to a database. Next you learn the fastest way to retrieve data using a DataReader. You then learn to handle exceptions and report back great debugging information. Disconnected classes such as a DataTable, DataSet and DataViews are explored next. Working with a the ADO.NET builder classes help automate some of your ADO.NET code. Finally, you see a great set of wrapper classes you can use to eliminate up to 90% of the ADO.NET code you used to have to write, without sacrificing efficiency. When you are finished with this course you will have the skills and knowledge to access databases in the most efficient manner possible, while using the least amount of code. Software required: Visual Studio 2019, .NET 4.5/.NET 5, C#.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

C#

Paul D. Sheriff

Instructor's Courses

Paul has over thirty years of experience architecting information systems and his expertise is in much demand from Fortune 500 companies. Paul is a Pluralsight author, has published 400+ articles, and authored over 14 books on topics ranging from JavaScript, Angular, C#, SQL Server and many .NET technologies. Paul is a frequent speaker at conferences and user groups.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.