| # |
Chapters & Strategies |
Topics |
| 1 |
Introduction to ADO.NET
|
- Microsoft Data Access Technologies
- From ADO to ADO.NET
- ADO.NET Architecture
- Namespaces and Classes
- Interfaces
- DataSets and Disconnected Access
- First ADO.NET Programs
- Acme Computer Case Study
|
| 2 |
ADO.NET Connections
|
- .NET Data Providers
- IDbConnection
- Connection Classes
- Connection Strings
- Connection Pooling
- Connection Events
- Error Handling
|
| 2 |
ADO.NET Connections
(Web offering only)
|
- Database Programs with ASP.NET
|
| 3 |
ADO.NET Commands
|
- IDbCommand
- Command Objects
- Creating Commands
- Executing Commands
- Parameterized Queries
- Command Types
- Using Stored Procedures
- Batch Queries
|
| 4 |
DataReaders and Connected Access
|
- DataReaders
- IDataReader
- IDataRecord
- Type-Safe Accessors
- Null Columns
- ExecuteReader Options
- Multiple Result Sets
- Obtaining Schema Information
|
| 5 |
Data Sets and Disconnected Access
|
- DataSet
- DataAdapter
- Command Objects
- DataTable
- DataColumn
- DataRow
- Row States and Versions
- Accept or Reject Changes
- DataTable Events
- Updating a Database from a DataSet
- Command Builders
|
| 6 |
More About DataSets
|
- Filtering DataTables
- Multiple Table DataSets
- Schema
- Constraints
- Relations
- Navigating a DataSet
- DataMapping
- Creating a DataSet Programmatically
|
| 7 |
XML and ADO.NET
(Not covered in the Windows and Web offerings)
|
- Strong Coupling Between ADO.NET and XML
- Rendering XML from a DataSet
- Controlling XML Output
- Reading XML into a DataSet
- XML Schema and DataSets
- Typed DataSets
- Table Adapters
- Synchronizing DataSets and XML
- XML Serialization
|
| 8 |
Data Binding
(Not covered in the Web offering)
|
- Data Binding in Windows Forms
- Simple Data Binding
- Complex Data Binding
- DataGrid Binding
- DataView
- Filtering and Sorting
- Data Binding with .NET
|
| 9 |
Concurrency and Transactions
|
- DataSets and Concurrency
- Optimistic Concurrency
- Pessimistic Concurrency
- Handling Concurrency Violations
- ADO.NET Transactions
- Database Transactions
|
| 10 |
New Features in ADO.NET
|
- Using Server Explorer in Visual Studio
- Asynchronous Database Operations
- Multiple Active Result Sets
- Bulk Copy in ADO.NET
|
| 10 |
LINQ to ADO.NET
|
- Language Integrated Query (LINQ)
- Bridging Objects and Data
- Using Object Relational Designer
- Filtering, Ordering and Aggregation
- Inserts, Deletes and Updates
- LINQ to SQL
- LINQ to Dataset
|
