Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Pluralsight

Implementing ADO.NET with C#

via Pluralsight

Overview

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.

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#.

Syllabus

  • 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

Taught by

Paul D. Sheriff

Reviews

4.5 rating at Pluralsight based on 99 ratings

Start your review of Implementing ADO.NET with C#

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.