2013
Pluralsight
Herve Roggero
4h 6m
English

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.

-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

http://pluralsight.com/

Download File Size:445.74 MB

---