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