ADO.NET Fundamentals

By Herve Roggero
Overview of ADO.NET including SqlConnection, SqlCommand, SqlDataAdapter.
Course info
Rating
(456)
Level
Intermediate
Updated
Oct 22, 2013
Duration
4h 7m
Table of contents
ADO.NET Overview
ADO.NET Overview 6m
Setting Up Your Environment
Introduction 1m Download Database 4m Create Project 2m
Connect to A Data Source Using ADO.NET
Introduction 5m Setup and Connecting with WinForm 4m Connecting with ASP.NET 2m SqlConnectionStringBuilder 4m Change ApplicationName 3m Conclusion 1m
Retrieving Data from A Data Source
Introduction 1m Build SQL Statement 4m Implement Data Layer 8m WinForm Application 6m ASP.NET Application 4m Stored Procedure 5m Summary 0m
Inserting, Deleting, Updating Data from A Data Source
Introduction 1m Prepare ExecuteNonQuery 2m Stored Procedure 2m Inserts With ExecuteNonQuery 3m Inserts With ExecuteScalar 3m Using Output Parameter 3m Using ReturnValue Parameter 2m Deletes With ExecuteNonQuery 4m Updates With ExecuteNonQuery 5m Apply Changes In ASP.NET 4m Summary 1m
Understanding Errors with ADO.NET
Introduction 6m Catch SqlException Errors 5m Use RAISEERROR 3m Change ASP.NET Application 3m Summary 1m
Using SqlDataAdapter
Introduction 3m Load A DataTable 3m Bind A DataTable 3m Update with SqlDataAdapter 7m Change ASP.NET Application 2m Summary 1m
Client Side Performance Tracking
Introduction 2m Setup 4m RetrieveStatistics 2m Display All Statistics 6m Roundtrips 2m Summary 1m
Managing Concurrency and Transactions
Introduction 5m Concurrency with WHERE clause 6m Concurrency with SqlDataAdapter 2m Concurrency with Timestamp 5m SqlTransaction 4m TransactionScope 4m Server Transactions 3m Summary 1m
Connection Pooling
Introduction 4m SQL Profiler and Pooling 3m Performance Monitor and Pooling 3m Impact of Connection String on Pooling 4m Resolve a Connection Pooling Bug 2m Summary 1m
Using XML with ADO.NET
Introduction 2m Writing XML 7m Reading XML 6m Summary 1m
Transient Fault Handling with ADO.NET
Introduction 5m Setup 3m Demo 10m Summary 1m
Performance Considerations with ADO.NET
Introduction 4m XML Input 13m MARS 6m Summary 1m
Description
Course info
Rating
(456)
Level
Intermediate
Updated
Oct 22, 2013
Duration
4h 7m
Description

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.

About the author
Herve Roggero
About the author

Herve Roggero, Windows Azure MVP and co-author of PRO SQL Server 2012 Practices, is the founder of Blue Syntax Consulting (http://www.bluesyntax.net/). Herve is the president of the Azure Florida Association.

You're the smartest person in the room

PROVE IT

Your team won't just close the skills gap

THEY'LL HURDLE IT