Advanced RDO/ADO Data Access Scenarios

Following are five data access scenarios that are more complex than simple Select queries. Each one is discussed in a succeeding topic. First, an RDO approach to the problem is shown, followed by the ADO solution so that you can compare how each is accomplished.

• Executing a Parameter Query
  
  
• Performing a Parameter-Driven Stored Procedure
  
  
• Running a Stored Procedure That Returns Multiple Resultsets
  
  
• Performing an Action Query
  
  
• Running an Optimistic Batch Query