Creating the Oracle Database Project

Create the Oracle Database Project as follows:

  1. From the File menu select New, then Project.
  2. Do the following when the new Project dialog appears:

Follow the same process to add a new Oracle Database Project to a currently open solution.

You can select the Add to Source Control check box. Visual Studio automatically adds the solution to source control after it is created. Alternatively, you can add the solution to source control in the Solution Explorer. See Viewing Oracle Database Project in Solution Explorer.

This section contains the following topics:

Adding Database References

After you enter a project name and location, the Add Database Reference dialog box appears. Select one Server Explorer connection to associate with the project. If there are no Server Explorer connections, then the Connection dialog box appears. You can also add a database reference after creating the project.

To create a new Server Explorer connection click Add New Reference. You may also click Cancel, specifying that no Server Explorer connections are associated with the project.

After you select OK or Cancel, the project is created and opens in Solution Explorer.

See Also

About Database References

Viewing Oracle Database Project in Solution Explorer

You can use Solution Explorer to view Oracle Database Project and to add its solution to source control.

To add a Oracle Database Project to source control, select the solution containing the Oracle Database Project and right-click on it. You will see the command Add Solution to Source Control. Select this and follows the commands indicated by your source control provider.

The default layout in Solution Explorer can be changed. For example, you can rename or delete folders. However, when you generate scripts, if the appropriate folder cannot be found, then the scripts go to the root of the project.