Using the DataDirect Wizards

Wizards simplify typical tasks that you perform when you create an application:

• Creating Tables With the Add Table Wizard
• Creating Views with the Add View Wizard

Before beginning this procedure, create a project using a DataDirect Connect template, as described in Creating a New Project, and add a data connection.

Creating Tables With the Add Table Wizard

You can quickly and easily define new tables in Visual Studio using the Progress DataDirect Connect for ADO.NET Add Table Wizard.

To create tables with the Add Table Wizard:

1. Select View / Server Explorer.

2. Double-click a data source connection to expose the nodes below it.

3. Right-click the Tables node, and select Add New Table. The Progress DataDirect Connect for ADO.NET Add Table Wizard appears.

4. Click Next. The Specify Table Name dialog box appears.

   

5. Specify the Table Schema and the Table Name:

   • In the Table Schema drop-down list, select a table schema.
   • In the Table Name field, type a name for the table.

6. Click Next. The Specify Column(s) dialog box appears.

   

7. Define the columns for the new table. Your choices may cause additional fields to appear in the Data Type Options pane.

   a. Click Add to add a column to the table. The Column Name and Data Type fields become editable.
   b. Type a name in the Column Name field.
   c. Select the data type for the column, and, if required, supply any additional information:

   • If you select a character data type (for example, Char), the Length field appears in the Data Type Options pane. Type the maximum size of the column (in bytes).
   • If you select Number for the Oracle data provider, the Precision and Scale fields appear in the Data Type Options pane.

   d. If the column can have a Null value, select the Allow Null check box.
   e. To remove a column from the table, select the column name, and then click Remove.

8. Click Next. The Specify Primary Key dialog box appears. Take one of the following actions:

   • If you do not want to specify a primary key for the table, select No Primary Key, and then click Next. The Specify Unique Key(s) dialog box appears. Continue at Step 11.
   • If you want to specify a primary key for the table, select Create Primary Key, and then continue at Step 9.

9. Complete the fields on the Specify Primary Key dialog box:

   • In the Primary Key Name field, type the name for the primary key, or accept the default name.

   • Select a column from the Available Columns field and click the arrow to move it to the Selected Columns field.

     

10. Click Next. The Specify Unique Key(s) dialog box appears.

    

11. (Optional) Specify one or more unique keys for the table. * If you do not want to specify unique keys for the table, click Next. The Specify Foreign Key(s) dialog box appears. Continue at Step 14.
    * If you want to specify one or more unique keys for the table, continue at Step 12.

12. Click Add. The fields on the dialog box become selectable:
    * In the Unique Keys drop-down list, select a unique key.
    * In the Unique Key Name field, edit the name or accept the default name.
    * In the Available Columns list box, select one or more columns to be used to specify the unique key, and click the arrow to move them to the Selected Columns list box.

13. Click Next. The Specify Foreign Key(s) dialog box appears.

    

14. (Optional) Specify one or more foreign keys for the table.
    * If you do not want to specify foreign keys for the table, click Next. The Review SQL dialog box appears. Continue at Step 17.
    * If you want to specify one or more foreign keys for the table, continue at Step 15.

15. Click Add. The fields on the dialog box become selectable:
    * In the Foreign Keys drop-down list, select a foreign key.
    * In the Foreign Key Name field, edit the name or accept the default name.
    * In the Table Schema drop-down list, select a table schema.
    * In the Table Name drop-down list, select a table schema.
    * In the Foreign Key Column drop-down list, select one or more columns to be used to specify the foreign key.
    * In the Parent Table Column drop-down list, select the corresponding column from the parent table.

16. Click Next. The Review SQL dialog box appears.

    

17. Review the SQL statement that has been generated by your choices. * If you are satisfied with the SQL statement, click Finish. The table that you created appears in Server Explorer under the Tables node for the connection. * If you want to supplement the SQL statement, for example, add a view or specific keywords, continue at Step 18.

18. Select the Edit SQL check box. The text in the Generated SQL field becomes editable.

    Note: When you select the Edit SQL check box, the Back button is disabled.

19. When you are satisfied with your changes to the SQL statement, click Finish. The table that you created appears in Server Explorer under the Tables node for the connection.

Creating Views with the Add View Wizard

You can quickly and easily define new views in Visual Studio using the Progress DataDirect Connect for ADO.NET Add View Wizard.

To add views with the Add View wizard:

1. Select View / Server Explorer.

2. Double-click a data source connection to expose the nodes under it.

3. Right-click the Views node, and select Add New View. The Progress DataDirect Connect for ADO.NET Add View Wizard welcome dialog box appears.

4. Click Next. The Specify View Name dialog box appears.

   

5. Specify the View Schema and the View Name.

   • Select a view schema from the View Schema drop-down list.
   • Type a name for the view in the View Name field.

6. Click Next. The Select Table(s) and/or Column(s) dialog box appears.

   

7. In the List of Tables and columns list box, select the tables or columns that will make up the view, and click the arrow to move them to the Selected Columns column.

8. Click Next. The Review SQL dialog box appears.

   

9. Review the SQL statement that has been generated by your choices.

   • If you are satisfied with the SQL statement, click Finish. The view that you created appears in Server Explorer under the Views node for the connection.
   • If you want to supplement the SQL statement, for example, add a view or specific keywords, continue at Step 10.

10. Select the Edit SQL check box. The text in the Generated SQL field becomes editable.

    Note: When you select the Edit SQL check box, the Back button is disabled.

11. When you are satisfied with your changes to the SQL statement, click Finish. The view that you created appears in Server Explorer under the Views node for the connection.