Implementing ADO.NET 4 with C# 8
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.
What you'll learn
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#.
Table of contents
- Module Introduction 0m
- The Connection Class 1m
- Opening a Connection 3m
- Employ a Using Block 1m
- Catching Connection Exceptions 2m
- Using ConnectionStrings.com 1m
- Retrieving a Scalar Value using a Command Object 2m
- Submit an INSERT Statement using ExecuteNonQuery 2m
- Submit a Query with Parameters 4m
- Submit an INSERT Statement with Parameters 2m
- Using OUTPUT Parameters 4m
- Transaction Processing 4m
- Module Summary 1m
- What are Disconnected Classes? 1m
- Loading a DataTable Using a SqlDataAdapter 5m
- Create a Generic List of Products from a DataTable 3m
- Multiple Result Sets and the DataSet Class 2m
- Using a DataView for Sorting 3m
- Filtering Data Using a DataView 2m
- Create a DataView using a LINQ statement 2m
- Convert a DataView Back to a DataTable 1m
- Module Summary 1m
- Overview of the ADO.NET Wrapper Classes 2m
- Diving into the Main ADO.NET Wrapper Classes 5m
- Retrieve Data Using Just a Few Lines of Code 3m
- Using Parameters to Search for Data 3m
- Retrieve Data Using a Stored Procedure 2m
- Getting Multiple Result Sets 2m
- Modifying Data 3m
- Transaction Processing 2m
- Module and Course Summary 1m
About the author
Paul has over thirty years of experience architecting information systems and his expertise is in much demand from Fortune 500 companies. Paul is a Pluralsight author, has published 400+ articles, and authored over 14 books on topics ranging from JavaScript, Angular, C#, SQL Server and many .NET technologies. Paul is a frequent speaker at conferences and user groups.