dotConnect for Oracle provides design-time integration with Visual Studio 2015, 2017, 2019, 2022, and 2026 through Data Designer Extensibility (DDEX). This integration lets you manage Oracle connections in Server Explorer and use Visual Studio's built-in data design tools, including DataSet Designer, Data Source Configuration Wizard, TableAdapter Configuration Wizard, Query Builder, and data preview features. You can also configure the SqlDataSource control in ASP.NET applications.
This article explains the available integration features and how to use them.
Server Explorer is a Visual Studio window for managing server connections and exploring database objects. With dotConnect for Oracle, you can create connections to Oracle servers and browse their databases.
Server Explorer lists database tables, views, stored procedures, and functions. Expand a node to view its columns or arguments.
Connections created in Server Explorer are also available to other Visual Studio data design tools.
To open Server Explorer, select View > Server Explorer.
The Add/Modify Connection dialog lets you create new Oracle connections and modify existing ones.

You can open the dialog in one of the following ways:
The following table describes the connection settings available in the dialog.
| Setting | Description |
|---|---|
| Host | Specifies the name or IP address of the Oracle server host to connect to. |
| User Id | Specifies the Oracle login account. |
| Password | Specifies the password for the Oracle login account. |
| Allow saving password | Saves the password along with the other connection parameters for future connections. |
After you specify the connection settings, click Test Connection to verify the connection, then click OK.
The Advanced Properties dialog provides access to all dotConnect for Oracle connection properties, including advanced settings that are not available in the Add/Modify Connection dialog. Use this dialog to configure additional connection parameters when necessary.
Data Source Configuration Wizard lets you create and configure data sources for your application. Data sources can be based on databases, web services, or objects and can be bound to controls that display data on forms.
For Windows Forms applications, the wizard can generate a DataSet and add it to your project. The generated DataSet appears in the Data Sources window, where you can drag its elements onto forms to create data-bound controls. You can further customize the DataSet using DataSet Designer and TableAdapter Configuration Wizard.
You can open Data Source Configuration Wizard in one of the following ways:

To create a data source:
After completing the wizard, you can view and modify the generated DataSet in Solution Explorer.
TableAdapter Configuration Wizard lets you create and configure TableAdapters based on SQL statements or existing stored procedures. The wizard can also create new stored procedures in the database based on the SQL statements you enter.
A TableAdapter connects to a database, executes queries or stored procedures, and populates a DataTable with the returned data. It can fill an existing DataTable or create and return a new one.
To open TableAdapter Configuration Wizard, open the DataSet in DataSet Designer, right-click the TableAdapter, and select Configure.
Parameterized queries let you retrieve data that matches specific conditions without hardcoding values into SQL statements.
For example, to retrieve customers from a particular city, add a WHERE clause with a parameter to your query.
The ? parameter lets you specify the city when executing the query.
To create a parameterized TableAdapter query, open the DataSet in DataSet Designer, right-click the TableAdapter, and select
Add Query. In the wizard, enter a SELECT statement with a parameter in the WHERE clause.
Web SQL Data Source Wizard lets you configure data sources for ASP.NET web controls. It provides functionality similar to Data Source Configuration Wizard.
To configure a data source for an ASP.NET web control: