| 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
|