Object Discovery Corporation

Course Outline for ADO.NET Using C# Training

Detailed Course Outline

# 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

Course Schedule and Location

  • ADO.NET Using C# On-site training - We come to your company to train your employees.

Back to Top

2008–2019 Object Discovery Corporation home | site map | our company | careers | legal