Using the PSQL Visual Studio 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 PSQL 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 PSQL ADO.NET 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 PSQL ADO.NET Add Table Wizard appears.
4
Click Next. The Specify Table Name dialog appears.
5
In the Table Name field, type a name for the table.
6
Click Next. The Specify Column(s) dialog appears.
7
Define the columns for the new table. Your choices may cause additional fields to appear in the Data Type Options pane.
•
Click Add to add a column to the table. The Column Name and Data Type fields become editable.
•
Type a name in the Column Name field.
•
Select the data type for the column, and, if required, supply any additional information:
•
If you select a character data type, the Length field appears in the Data Type Options pane. Type the maximum size of the column (in bytes).
•
If you select Number, the Precision and Scale fields appear in the Data Type Options pane.
•
If the column can have a Null value, select the Allow Null check box.
•
To remove a column from the table, select the column name and then click Remove.
8
Click Next. The Specify Primary Key dialog appears.
9
Do one of the following:
•
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 appears. Continue at Step 12.
•
If you want to specify a primary key for the table, select Create Primary Key, and then continue at Step 10.
10
Complete the fields on the Specify Primary Key dialog:
•
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 move it to the Selected Columns field.
11
Click Next. The Specify Unique Key(s) dialog appears.
12
Do one of the following:
•
If you do not want to specify unique keys for the table, click Next. The Specify Foreign Key(s) dialog appears. Continue at Step 15.
•
If you want to specify one or more unique keys for the table, continue at Step 15.
13
Click Add. The fields on the dialog 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 move them to the Selected Columns list box.
14
Click Next. The Specify Foreign Key(s) dialog appears.
15
Do one of the following:
•
If you do not want to specify foreign keys for the table, click Next. The Review SQL dialog appears. Continue at Step 18.
•
If you want to specify one or more foreign keys for the table, continue at Step 16.
16
Click Add. The fields on the dialog 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 list, select a table schema.
•
In the Table Name list, select a table schema.
•
In the Foreign Key Column list, select one or more columns to be used to specify the foreign key.
•
In the Parent Table Column list, select the corresponding column from the parent table.
17
Click Next. The Review SQL dialog appears.
18
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 19.
19
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.
20
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 PSQL Add View Wizard.
1
Select View > Server Explorer if it is not already open.
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 PSQL Add View Wizard welcome dialog appears.
4
Click Next. The Specify View Name dialog appears.
5
Type a name for the view in the View Name field.
6
Click Next. The Select Table(s) and/or Column(s) dialog appears.
7
In the List of Tables and columns list box, select the tables or columns that will make up the view, and move them to the Selected Columns column.
8
Click Next. The Review SQL dialog 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 11.
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.