Chapter 9 - Creating Data Services (Database Management): Part II

( Contents )

This is the second chapter that discusses data access. The preceding chapter Chapter 8, "Creating Data Services: Part I" introduced ADO concepts and discussed general ADO programming techniques.

This chapter focuses on some of the more specialized concerns with ADO programming, including various data-access models, the use of SQL and stored procedures, record locking, and database transactions.

Contents

1. ADO Data-Access Models
   Accessing Data With the Execute Direct Model
   Accessing Data With the Prepare/Execute Model
   Accessing Data With the Stored Procedures Model
   How to Choose a Data-Access Model

2. Using Stored Procedures
   Creating Stored Procedures
   Using the Parameters Collection to Manipulate and Evaluate Parameters for Stored Procedures
   Using Stored Procedures to Execute Statements on a Database
   Using Stored Procedures to Execute Processes Without Cursors
   Using Stored Procedures to Return Records to an Application

3. Using Cursors
   Using Cursor Locations
   Using Cursor Types

4. Managing Database Transactions

5. Writing SQL Statements
   Writing SQL Statements that Retrieve and Modify Data
         Using the Where Clause to Filter Rows
         Using the Order By Clause to Logically Sort Rows
   Writing SQL Statements that Use Joins to Combine Data from Multiple Tables
         Using the Where Clause to Connect Tables
         Using JOIN Clauses to Connect Tables

6. Using Locking Strategies to Ensure Data Integrity

7. Choosing Cursor Options