Pluralsight - ADO.NET Fundamentals
Pluralsight - ADO.NET Fundamentals
WMV | WMV3 162kbps | English | 1024x768 | 15fps | 4h 06mins | WMA2 stereo 128kbps | 503 MB
Genre: Video Training
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.
│ 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
Format : Windows Media
File size : 10.5 MiB
Duration : 4mn 47s
Overall bit rate mode : Variable
Overall bit rate : 306 Kbps
Maximum Overall bit rate : 484 Kbps
Movie name : adodotnet-fundamentals-m05
Performer : Herve Roggero
Encoded date : UTC 2013-10-04 16:20:50.762
Video #2
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 : 4mn 47s
Bit rate mode : Variable
Bit rate : 162 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.014
Stream size : 5.57 MiB (53%)
Language : English (US)
Audio #1
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 : 4mn 47s
Bit rate mode : Constant
Bit rate : 128 Kbps
Channel(s) : 2 channels
Sampling rate : 44.1 KHz
Bit depth : 16 bits
Stream size : 4.39 MiB (42%)
Language : English (US)
Pluralsight - ADO.NET Fundamentals
Pluralsight - ADO.NET Fundamentals
Pluralsight - ADO.NET Fundamentals
No mirrors please