Implementing ADO.NET with 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
(66)
Level
Intermediate
Updated
Feb 2, 2021
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
(66)
Level
Intermediate
Updated
Feb 2, 2021
Duration
2h 29m
Description

In this course, Implementing ADO.NET with 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/.NET 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
C# Language-Integrated Query (LINQ)
Intermediate
2h 32m
Mar 17, 2021
Working with XML in C#
Intermediate
1h 48m
Feb 2, 2021
More courses by Paul D. Sheriff
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
[Autogenerated] for loop. Hello. My name is Paul, Sheriff. And welcome to my course implementing a do .NET with C#. I am 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 gonna learn why a do .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 the data reader working with stored procedures and parameters. How to get great exception information to track down bugs easily Build extension methods to handle multiple fields. Use a data view to sort and filter data in memory. Use a set of rapper classes to eliminate 90% of your A do .NET code. By the end of this course, you'll have gained the knowledge necessary to create fast, efficient data access code using a do .NET or this course I assume you're familiar with C# and data access methodologies. I hope you'll join me on your journey to learning a do .NET in my courts, implementing a do .NET with C# at Pluralsight dot com.