ADO.NET Fundamentals in C#

By Paul D. Sheriff
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.
Play course overview
Course info
Rating
(45)
Level
Intermediate
Updated
Sep 5, 2019
Duration
2h 28m
Table of contents
Course Overview
Course Overview 2m
Why You Still Need to Know ADO.NET
Introduction and Assumptions 1m Modules in this Course 2m Why ADO.NET Still Matters 1m The Classes of ADO.NET 3m ORM's and ADO.NET 3m Demo of Sample Code from this Course 4m Module summary 1m
Connecting and Submitting Queries to a Database
Module Introduction 0m The Connection Class 1m Opening a Connection 3m Employ a Using Block 1m Catching Connection Exceptions 2m Using ConnectionStrings.com 1m Retrieving a Scalar Value using a Command Object 2m Submit an INSERT Statement using ExecuteNonQuery 2m Submit a Query with Parameters 4m Submit an INSERT Statement with Parameters 2m Using OUTPUT Parameters 4m Transaction Processing 4m Module Summary 1m
Retrieve Data Quickly Using the SqlDataReader
Introduction to DataReaders 1m Processing Rows in a DataReader 3m The DataReader Methods GetOrdinal, GetInt32, and Others 3m Demo of DataReader Methods 3m Using the GetFieldValue Method 2m Create Extension Method to Handle Nulls 3m Multiple Result Sets 3m Module Summary 1m
Handling ADO.NET Exceptions
Introduction to Exception Handling 1m Simple Exception Handling 2m Catching a SqlException to Gather More Information 4m How to Create a SqlExceptionManager Class 3m Demo of SqlExceptionManager Class 4m Walk Through of the SqlExceptionManager Class 7m Module Summary 1m
Disconnected Classes Are Useful
What are Disconnected Classes? 1m Loading a DataTable Using a SqlDataAdapter 5m Create a Generic List of Products from a DataTable 3m Multiple Result Sets and the DataSet Class 2m Using a DataView for Sorting 3m Filtering Data Using a DataView 2m Create a DataView using a LINQ statement 2m Convert a DataView Back to a DataTable 1m Module Summary 1m
The Building Blocks of the DataTable
Module Introduction 1m Create a DataTable using C# 4m Cloning and Copying DataTables 2m Using Select Method to Filter Rows 3m The CopyToDataTable Method 2m Module Summary 1m
Builder Classes Make It Easy to Work with ADO.NET
Introduction to SqlConnectionStringBuilder 1m Break Apart a Connection String 2m Create a Connection String Using SqlConnectionStringBuilder 2m Using the SqlCommandBuilder 3m Inserting a Product using the SqlCommandBuilder 2m Module Summary 1m
Making ADO.NET Easy to Use
Overview of the ADO.NET Wrapper Classes 2m Diving into the Main ADO.NET Wrapper Classes 5m Retrieve Data Using Just a Few Lines of Code 3m Using Parameters to Search for Data 3m Retrieve Data Using a Stored Procedure 2m Getting Multiple Result Sets 2m Modifying Data 3m Transaction Processing 2m Module and Course Summary 1m
Description
Course info
Rating
(45)
Level
Intermediate
Updated
Sep 5, 2019
Duration
2h 28m
Description

In this course, ADO.NET Fundamentals in C#, 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+, C#.

About the author
Paul D. Sheriff
About the author

Paul loves teaching and technology, and has been teaching tech and business topics for over 30 years. Paul helps clients develop applications, and instructs them on the best use of technology.

More from the author
JavaScript REST APIs: Getting Started
Beginner
1h 23m
Jun 19, 2020
Working with Geolocation in HTML
Intermediate
1h 35m
Apr 6, 2020
WPF for the Visual Basic Programmer
Beginner
1h 52m
Jan 21, 2020
More courses by Paul D. Sheriff
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hello. My name is Paul Sheriff, and welcome to my course, ADO.NET Fundamentals in C#. I'm a business solutions architect at Fairway Technologies with over 32 years of experience creating enterprise applications. Do you need the fastest data access speed in your .NET application? Are you disillusioned with the Entity Framework and just want something simple to access your database? If so, then this course is designed for you. In this course, you're going to learn why ADO.NET is still relevant and is the most efficient means of accessing data. Some of the major topics you will learn are connecting and submitting queries, how to submit and handle transactions, retrieving data quickly using a data reader, working with stored procedures and parameters, how to get great exception information to track down bugs easily, build extension methods to handle nullable fields, use a DataView to sort and filter data in memory, use a set of wrapper classes to eliminate 90% of your ADO.NET code. By the end of this course, you'll have gained the knowledge necessary to create fast, efficient data access code using ADO.NET. For this course, I assume you are familiar with C# and data access methodologies. I hope you'll join me on your journey to learning ADO.NET in my course, ADO.NET Fundamentals in C#, at Pluralsight.com.

You're the smartest person in the room

PROVE IT

Your team won't just close the skills gap

THEY'LL HURDLE IT