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#.
Author Name: Paul D. Sheriff
Author Description:
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.

Table of Contents

• Course Overview
  1min
• Why You Still Need to Know ADO.NET
  15mins
• Connecting and Submitting Queries to a Database
  26mins
• Retrieve Data Quickly Using the SqlDataReader
  18mins
• Handling ADO.NET Exceptions
  22mins
• Disconnected Classes Are Useful
  19mins
• The Building Blocks of the DataTable
  11mins
• Builder Classes Make It Easy to Work with ADO.NET
  10mins
• Making ADO.NET Easy to Use
  23mins