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

Download File Size:445.77 MB

---