OxyGen Code Generator Overview. 4   Table of Contents. 4
Previous Topic: Specifying Table Processing Instructions. 4   Next Topic: Generating Virtual Views. 4

 

Specifying View Processing Instructions

In this chapter, we will show how to specify the Processing Instructions that are used for views

  1. Open OxyGen Code Management Studio.
  2. In the Connect to Server dialog specify the Server Name (the default instance of SQL Server often uses the machine name), the Authentication mode, user credentials (if SQL Server Authentication is selected), and then click the Connect button.

Figure 9: Connection to Server dialog

Figure 10: Initial View

The Database Explorer tree control is populated with the databases from the specified server. Accessible databases are depicted by an enabled cylinder () while the databases that are not accessible are depicted by a disabled cylinder ().

 

NoteNote

In Windows Vista, some of the databases may be not accessible if Windows Authentication is selected and the application does not run under an administrator role.

Figure 11: View Processing Instructions panel

  1. On Database Explorer select a database (AdventureWorks) and a view (HumanResources.vEmployee). The Processing Instructions panel is displayed, as shown in the following screen shot. You will notice that there are three tabs in the main panel.
    1. View Processing:  configures the following Processing Instructions
      1. Cacheable
      2. Entity Name
      3. Reference Type Marker
      4. Resolve Many-To-Many
      5. Select
      6. Get All Order Criteria
      7. Search
      8. Persistent Storage
      9. Updateable Primary Key
      10. Virtualization Settings
    2. Column Processing: configure the following Processing Instructions
      1. Field Name
      2. Identifier Indicator
      3. Name Indicator
      4. Persistent Storage
    3. SQL Script (Read Only). Shows an SQL Script used to generate a given view.
  2. Double click on the processing instruction insertion button  (the last column in the processing instructions grid). The Processing Instruction dialog box appears, as shown in the following screen shot.

Figure 12: Table Processing dialog box

  1. Choose the Processing Instruction Type, specify the processing instruction parameters (if the selected processing instruction requires parameters) and click the OK button. To close the dialog without saving the changes click the Cancel button. Appendix A describes the processing instruction types and the parameters associated to each processing instruction.

OxyGen Code Generator Overview. 4   Table of Contents. 4
Previous Topic: Specifying Table Processing Instructions. 4   Next Topic: Generating Virtual Views. 4