C#.NET ADO Training

COURSE OUTLINE - C#.NET ADO TRAINING
Includes: 3 CD-ROMs & Reference Text
Running Time: Approx. 6 Hours of Instructor-Led Training

C#.NET Phase V- ADO
1.0 Introduction to ADO.NET
1.1 Creating an OleDb And SQLClient Connection
1.2 Using the IDbConnection Interface
1.3 Start The Data Access Class Library
1.4 Executing Action Queries With The Command Object
1.5 Executing Scalar Queries With The Command Object
1.6 The Different Scalar Return Types
1.7 Add The Command Object To The Class Library
2.0 The Datareader Class
2.1 Introduction
2.2 Get Data by Ordinal Position
2.3 Get Specific Data Types
2.4 Automatically Close The Connection
2.5 Get One Row of Data
2.6 Read Columns Sequentially
2.7 Combine Multiple Command Behaviors
2.8 Return Multiple Result Sets
2.9 Add The Datareader To The Class Library
2.10 Nested Data Readers
3.0 Parameterized Queries
3.1 Introduction
3.2 A Query With Multiple OleDb Parameters
3.3 Solving The String Delimiter Problem
3.4 A Query Wit hMuyltiple SqlClient Parameters
3.5 Add Parameterized Queries To The Class Library
4.0 Stored Procedures
4.1 Introduction
4.2 OleDb Stored Procedures With One Parameter
4.3 OleDb With Inputs, Outputs, And Return Values
4.4 OleDb Alternate Syntax
4.5 SqlClient With Inputs, Outputs, And Return Value

C#.NET Phase VI – ADO
1.0 Introduction to DataTables
1.1 Introduction to Data Tables
1.2 Adding DataColumns
1.3 Adding DataRows
1.4 Adding Primary Keys
1.5 Adding Unique Constraints
1.6 Adding Multi Column Constraints
1.7 Adding Read Only Columns
1.8 Allow Null Values in Selected Columns
1.9 Set A Max Length For Text Columns
1.10 Use An Autoincrement For a Primary Key
1.11 Add A Calculated Column
1.12 Calculations Based On a Group of Rows
2.0 DataTable Row
2.1 Find a Data Table Row Using The Primary Key
2.2 Selecting A Set of Rows
2.3 Using The RowState Property
2.4 The BeginEdit. EndEdit, and CancelEdit Methods
2.5 Using The RowVersions
2.6 Selecting Rows Using RowVersion
2.7 Row Versiuon With BeginEdit and EndEdit
2.8 Create one DataTable From Another
2.9 Using DataViews
3.0 Introduction to DataSets
3.1 Introduction to DataSets
3.2 Adding DataTables To A DataSets
3.3 Foreign Key Constraints
3.4 Cascading Updates
3.5 Enforce Referential Integrity
3.6 Null Values in Foreign Keys
3.7 Adding Relationships
3.8 Using Relationships To Get Child Rows
3.9 Using Relationships to Get Parent Row
4.0 Introduction to DataAdapters
4.1 Introduction To DataAdapters
4.2 Filling a DataSet
4.3 TableMappings
4.4 TableMapping Pass Through Fields
4.5 TableMapping Blocked Fields
4.6 Throw An Exception For Unmapped Fields
4.7 Get A DataSet From The Class Library

C#.NET Phase VII – ADO
1.0 Working with Data Adapter
1.1 Update Data with Data Adapter
1.2 Insert and Delete Data with Data Adapter
1.3 Save Changes Without a Data Adapter
1.4 Save Changes Using Stored Procedures
1.5 Dealing with Concurrency Issues
1.6 Detecting a Failed Concurrency Issue
1.7 Using Transactions
2.0 Using Visual Database Tools
2.1 Introduction to the Visual Database Tools
2.2 Adding a DataAdapter Using the Visual Tools
2.3 Using the DataAdapter to Fill a DataSet
2.4 The Problem With Regular DataSets
2.5 Solving The Problem With Typed DataSets
2.6 The Problem With Typed DataSets
2.7 Using The Visual Tools vs Programming
3.0 Using Data Application Block
3.1 Introducing the Data Access Application Block
3.2 Examining the DAAB Help File
3.3 Adding the DAAB to a Project and Creating a Simple Dataset
3.4 Create a Wrapper Around the DAAB
3.5 Using Stored Procedures to Create Dataset
3.6 A Stored Procedure Parameter Wrapper
3.7 Wrapper Class Code Generator