In this chapter, we will show how to
specify the Processing Instructions that are used for tables
Open OxyGen Code Management Studio.
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 5: Connect to Server dialog
Figure 6: 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 ().
Note
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 7: Table Processing Instructions panel
On Database
Explorer select a database (AdventureWorks) and a table (HumanResources.Department).
The Processing
Instructions panel is displayed, as shown in the following
screen shot. You will notice that there are two tabs in the main panel.
Table Processing: configures the
following Processing Instructions
Cacheable
Entity Name
Reference Type Marker
Resolve Many-To-Many
Select
Get All Order Criteria
Search
Persistent Storage
Updateable Primary Key
Column Processing: configure the
following Processing Instructions
Field Name
Identifier Indicator
Name Indicator
Persistent Storage
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 8: Table Processing dialog box
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.
) while the databases that are not accessible are depicted by a
disabled cylinder (
).
(the last column in the processing instructions grid). The Processing Instruction
dialog box appears, as shown in the following screen shot.
