ADO.NET Fundamentals [2013, ENG]

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

ADO.NET Fundamentals

Год выпуска: 2013
Производитель: Pluralsight
Сайт производителя: http://pluralsight.com/
Автор: Herve Roggero
Продолжительность: 4h 6m
Тип раздаваемого материала: Видеоклипы
Язык: Английский
Описание: Overview of ADO.NET including SqlConnection, SqlCommand, SqlDataAdapter.
Introduction to ADO.NET with an overview of many SqlClient objects, concurrency and transaction management overview, Transient Fault Handling Application Block, performance considerations and dealing with XML data.

Обзор ADO.NET включая SqlConnection, SqlCommand, SqlDataAdapter.
Введение в ADO.NET с обзором многих SqlClient объектов, параллелизм и управление транзакциями обзор, переходные Обработка ошибок Application Block, соображения производительности и дело с XML-данными.
[spoiler="Содержание"]
│ adodotnet-fundamentals.zip
│
├───01. ADO.NET Overview
│ 01. ADO.NET Overview.wmv
│
├───02. Setting Up Your Environment
│ 01. Introduction.wmv
│ 02. Download Database.wmv
│ 03. Create Project.wmv
│
├───03. Connect to A Data Source Using ADO.NET
│ 01. Introduction.wmv
│ 02. Setup and Connecting with WinForm.wmv
│ 03. Connecting with ASP.NET.wmv
│ 04. SqlConnectionStringBuilder.wmv
│ 05. Change ApplicationName.wmv
│ 06. Conclusion.wmv
│
├───04. Retrieving Data from A Data Source
│ 01. Introduction.wmv
│ 02. Build SQL Statement.wmv
│ 03. Implement Data Layer.wmv
│ 04. WinForm Application.wmv
│ 05. ASP.NET Application.wmv
│ 06. Stored Procedure.wmv
│ 07. Summary.wmv
│
├───05. Inserting, Deleting, Updating Data from A Data Source
│ 01. Introduction.wmv
│ 02. Prepare ExecuteNonQuery.wmv
│ 03. Stored Procedure.wmv
│ 04. Inserts With ExecuteNonQuery.wmv
│ 05. Inserts With ExecuteScalar.wmv
│ 06. Using Output Parameter.wmv
│ 07. Using ReturnValue Parameter.wmv
│ 08. Deletes With ExecuteNonQuery.wmv
│ 09. Updates With ExecuteNonQuery.wmv
│ 10. Apply Changes In ASP.NET.wmv
│ 11. Summary.wmv
│
├───06. Understanding Errors with ADO.NET
│ 01. Introduction.wmv
│ 02. Catch SqlException Errors.wmv
│ 03. Use RAISEERROR.wmv
│ 04. Change ASP.NET Application.wmv
│ 05. Summary.wmv
│
├───07. Using SqlDataAdapter
│ 01. Introduction.wmv
│ 02. Load A DataTable.wmv
│ 03. Bind A DataTable.wmv
│ 04. Update with SqlDataAdapter.wmv
│ 05. Change ASP.NET Application.wmv
│ 06. Summary.wmv
│
├───08. Client Side Performance Tracking
│ 01. Introduction.wmv
│ 02. Setup.wmv
│ 03. RetrieveStatistics.wmv
│ 04. Display All Statistics.wmv
│ 05. Roundtrips.wmv
│ 06. Summary.wmv
│
├───09. Managing Concurrency and Transactions
│ 01. Introduction.wmv
│ 02. Concurrency with WHERE clause.wmv
│ 03. Concurrency with SqlDataAdapter.wmv
│ 04. Concurrency with Timestamp.wmv
│ 05. SqlTransaction.wmv
│ 06. TransactionScope.wmv
│ 07. Server Transactions.wmv
│ 08. Summary.wmv
│
├───10. Connection Pooling
│ 01. Introduction.wmv
│ 02. SQL Profiler and Pooling.wmv
│ 03. Performance Monitor and Pooling.wmv
│ 04. Impact of Connection String on Pooling.wmv
│ 05. Resolve a Connection Pooling Bug.wmv
│ 06. Summary.wmv
│
├───11. Using XML with ADO.NET
│ 01. Introduction.wmv
│ 02. Writing XML.wmv
│ 03. Reading XML.wmv
│ 04. Summary.wmv
│
├───12. Transient Fault Handling with ADO.NET
│ 01. Introduction.wmv
│ 02. Setup.wmv
│ 03. Demo.wmv
│ 04. Summary.wmv
│
└───13. Performance Considerations with ADO.NET
01. Introduction.wmv
02. XML Input.wmv
03. MARS.wmv
04. Summary.wmv
[/spoiler]
Файлы примеров: присутствуют
Формат видео: WMV
[spoiler="audio\video"]
General
Complete name : C:\01. ADO.NET Overview.wmv
Format : Windows Media
File size : 8.74 MiB
Duration : 5mn 47s
Overall bit rate mode : Variable
Overall bit rate : 211 Kbps
Maximum Overall bit rate : 609 Kbps
Movie name : adodotnet-fundamentals-m01-001
Performer : Herve Roggero
Encoded date : UTC 2013-10-12 20:29:10.351

Video
ID : 2
Format : VC-1
Format profile : MP@HL
Codec ID : WMV3
Codec ID/Info : Windows Media Video 9
Codec ID/Hint : WMV3
Description of the codec : Windows Media Video 9
Duration : 5mn 47s
Bit rate mode : Variable
Bit rate : 38.9 Kbps
Width : 1 024 pixels
Height : 768 pixels
Display aspect ratio : 4:3
Frame rate : 15.000 fps
Color space : YUV
Chroma subsampling : 4:2:0
Bit depth : 8 bits
Scan type : Progressive
Compression mode : Lossy
Bits/(Pixel*Frame) : 0.003
Stream size : 1.61 MiB (18%)
Language : English (US)

Audio
ID : 1
Format : WMA
Format version : Version 2
Codec ID : 161
Codec ID/Info : Windows Media Audio
Description of the codec : Windows Media Audio 9.2 - 128 kbps, 44 kHz, stereo 1-pass CBR
Duration : 5mn 47s
Bit rate mode : Constant
Bit rate : 128 Kbps
Channel(s) : 2 channels
Sampling rate : 44.1 KHz
Bit depth : 16 bits
Stream size : 5.31 MiB (61%)
Language : English (US)
[/spoiler]
[spoiler="Скриншоты"]

[/spoiler]