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