ADO.NET

SQL Data Connection Object

The Data Connection is a lifeline between the Data Provider (in this case, SQL Server) and your .NET application. This video shows how to use many of the properties and methods, as well as the two events that are raised by the Connection object.

SQL Data Command Object

The SQL Data Command object allows you to perform commands and request data from a data source. This video demonstrates many of the methods and properties of the Data Command object.

Using the Data Command's Parameter Collection

When using stored procedures, you will often make use of input and output parameters. To populate or read from the parameters, you will need to add items to the Parameters collection. This video shows several techniques of how to accomplish this.

Sql DataReader Object

The SQL Data Reader is an object that allows you to read the data that is retrieved from a Data Command. It is refered to as a "fire-hose" connection, because you can only read in one direction (and can't jump back and forth through the Data Reader as you would an array or collection). This video shows several techniques of how to retrieve values and metadata from the Data Reader.

SqlDataAdapter

Since DataSets are completely disconnected from their data source, a special adapter is needed to resolve any changes made to the DataSet back to the original data source. The SqlDataAdapter knows how to resovlve Updates, Deletes and Inserts, and this video demonstrates how it works. Also shows the DataAdapter events that can be captured by your applications.

Using Access in ADO.NET

Demonstrates how to connect to an Access database using ADO.NET and the Server Explorer, create a DataAdapter, DataSet and data bind.

Dataset Concepts

This video is a slide show that explains many key concepts like the difference between strongly typed and untyped datasets, how a dataset is different from a datareader, the XML/Dataset connection and more.

Strongly Typed Datasets via DataAdapter

Demonstrates how to create a strongly typed dataset using the "Generate Dataset" function of the DataAdapter

Strongly Typed Datasets via XML Schema Designer

Demonstrates how to create a strongly typed dataset using the XML Schema Designer

Creating Untyped Datasets at Runtime

Demonstrates how to create untyped datasets at runtime, including the creation of DataTables and DataColumns.

Creating Untyped Datasets using VS.NET Editors

Demonstrates how to use the built in VS.NET Collection Editors to create untyped datasets

Understanding Concurrency

This video explains what concurrency is, the difference between Optimistic and Pessimistic concurrency, and how Concurrency is supported in ADO.NET and VS.NET.

Optimistic Concurrency

This video demonstrates Optimistic Concurrency ... VB.NET and C# versions available. Uses ADO.NET's RowUpdated event that fires when calling the DataAdapter.Update method. Shows how to set the RowError and Status (using UpdateStatus enum), and use the HasErrors property of the DataRow.

A "Home Grown" Pessimistic Concurrency Example

This video demonstrates some of the pitfalls typically encountered when attempting to create a home-grown custom implementation of pessimistic concurrency.

Pessimistic Concurrency Using Transactions

This video demonstrates the use of the ADO.NET Transaction object and its various IsolationLevels to implement pessimistic concurrency in your applications. Explains exclusive and shared locking, "dirty reads", and more.

Persisting a Dataset to XML

Persisting a Dataset to XML

Optimizing DataReader Data Access

Optimizing DataReader Data Access

ADO.NET Connection Pooling

ADO.NET Connection Pooling

Understanding DataRow States and Versions

Understanding DataRow States and Versions

ADO.NET DataView

ADO.NET DataView

DataColumns.Expression

DataColumns.Expression