Implementing ADO.NET with C# [2021, ENG]

Обучающие видео » Компьютерные видеоуроки и обучающие интерактивные DVD » Программирование (видеоуроки)

Implementing ADO.NET with C#

Год выпуска: 2021
Производитель: Pluralsight
Сайт производителя: https://www.pluralsight.com/courses/csharp-ado-dotnet-fundamentals
Автор: Paul D. Sheriff
Продолжительность: 2h 29m
Тип раздаваемого материала: Видеоурок
Язык: Английский
Субтитры: Английские (ручные), Русские (автоперевод)
Описание: 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#.
[spoiler="Все курсы .NET Base Class Library Path"]
[spoiler="Beginner"]
Working with Files and Streams in C#
Implementing ADO.NET with C#
Using HttpClient to Consume APIs in .NET Core
[/spoiler]
[spoiler="Intermediate"]
Getting Started with JSON in C# Using Json.NET
Working with XML in C# (Отсутствует на трекере)
[/spoiler]
[spoiler="Advanced"]
Building Secure Applications with Cryptography in .NET (Отсутствует на трекере)
.NET Regular Expressions (Отсутствует на трекере)
[/spoiler]
[/spoiler]
[spoiler="Содержание"]
01. Course Overview:
01. Course Overview

02. Why You Still Need to Know ADO.NET:
01. Introduction and Assumptions
02. Modules in this Course
03. Why ADO.NET Still Matters
04. The Classes of ADO.NET
05. ORMs and ADO.NET
06. Demo of Sample Code from this Course
07. Module summary

03. Connecting and Submitting Queries to a Database:
01. Module Introduction
02. The Connection Class
03. Opening a Connection
04. Employ a Using Block
05. Catching Connection Exceptions
06. Using ConnectionStrings.com
07. Retrieving a Scalar Value using a Command Object
08. Submit an INSERT Statement using ExecuteNonQuery
09. Submit a Query with Parameters
10. Submit an INSERT Statement with Parameters
11. Using OUTPUT Parameters
12. Transaction Processing
13. Module Summary

04. Retrieve Data Quickly Using the SqlDataReader:
01. Introduction to DataReaders
02. Processing Rows in a DataReader
03. The DataReader Methods GetOrdinal, GetInt32, and Others
04. Demo of DataReader Methods
05. Using the GetFieldValue Method
06. Create Extension Method to Handle Nulls
07. Multiple Result Sets
08. Module Summary

05. Handling ADO.NET Exceptions:
01. Introduction to Exception Handling
02. Simple Exception Handling
03. Catching a SqlException to Gather More Information
04. How to Create a SqlExceptionManager Class
05. Demo of SqlExceptionManager Class
06. Walk Through of the SqlExceptionManager Class
07. Module Summary

06. Disconnected Classes Are Useful:
01. What are Disconnected Classes
02. Loading a DataTable Using a SqlDataAdapter
03. Create a Generic List of Products from a DataTable
04. Multiple Result Sets and the DataSet Class
05. Using a DataView for Sorting
06. Filtering Data Using a DataView
07. Create a DataView using a LINQ statement
08. Convert a DataView Back to a DataTable
09. Module Summary

07. The Building Blocks of the DataTable:
01. Module Introduction
02. Create a DataTable using C#
03. Cloning and Copying DataTables
04. Using Select Method to Filter Rows
05. The CopyToDataTable Method
06. Module Summary

08. Builder Classes Make It Easy to Work with ADO.NET:
01. Introduction to SqlConnectionStringBuilder
02. Break Apart a Connection String
03. Create a Connection String Using SqlConnectionStringBuilder
04. Using the SqlCommandBuilder
05. Inserting a Product using the SqlCommandBuilder
06. Module Summary

09. Making ADO.NET Easy to Use:
01. Overview of the ADO.NET Wrapper Classes
02. Diving into the Main ADO.NET Wrapper Classes
03. Retrieve Data Using Just a Few Lines of Code
04. Using Parameters to Search for Data
05. Retrieve Data Using a Stored Procedure
06. Getting Multiple Result Sets
07. Modifying Data
08. Transaction Processing
09. Module and Course Summary
[/spoiler]
Файлы примеров: присутствуют
Формат видео: MP4
Видео: H264, 1280x720, 30 fps, 206 kb/s
Аудио: AAC, 48 kHz, 94 kb/s, Stereo
[spoiler="Скриншоты"]

[/spoiler]