ADO.NET Fundamentals in C#

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.
Course info
Rating
(11)
Level
Intermediate
Updated
Sep 5, 2019
Duration
2h 29m
Table of contents
Course Overview
Why You Still Need to Know ADO.NET
Connecting and Submitting Queries to a Database
Retrieve Data Quickly Using the SqlDataReader
Handling ADO.NET Exceptions
Disconnected Classes Are Useful
The Building Blocks of the DataTable
Builder Classes Make It Easy to Work with ADO.NET
Making ADO.NET Easy to Use
Description
Course info
Rating
(11)
Level
Intermediate
Updated
Sep 5, 2019
Duration
2h 29m
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
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 Syntax and Operators
Beginner
1h 42m
Nov 12, 2019
VB.NET Fundamentals
Beginner
3h 26m
May 21, 2019
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.