Visual Studio 2008 - 2017 Advanced Integration
dotConnect for Oracle integrates tightly with design-time features of Visual Studio
2008, 2010, 2012, 2013, 2015, and 2017 such as Server Explorer. This is also mentioned as Data Designer
Extensibility features, or DDEX. The integration helps to design applications
in more convenient and fast way. For example, you can take advantage of DataSet
Designer, Data Source wizard, Query Builder, TableAdapter configuration, use Preview
Data capability and configure web SqlDataSource component.
This topic provides information on what new features are available and how to use
Note that DDEX is not available for Compact Framework projects and in Visual Studio
Express editions except Microsoft Web Developer Express 2008 and 2010.
This article consists of the following sections:
Integrating with Server Explorer
Server Explorer is the server management console for Visual Studio. Use this window
to open data connections and to log on to servers and explore their databases. With
Server Explorer you can view and retrieve information from all of the databases
you are connected to. Use Server Explorer to list database tables, views, stored
procedures, functions, and expand individual nodes to list their columns or arguments.
Connections created with Server Explorer are later available in other parts of Visual
Studio such as Data Designers.
To access Server Explorer, choose Server Explorer on the View menu.
Add/Modify Connection Dialog Box
This dialog box allows you to create and modify database connections. There are
four ways to access this dialog box:
- From the Tools menu select Connect to Database.
- Right-click the Data Connections node in Server Explorer and click Add
- From the Database menu select Modify Connection.
- Right-click the data connection you want to modify in Server Explorer and click
The dialog consists of several controls where you supply information needed to connect
to server. The following list describes most important controls.
The name or IP address of host of Oracle database to which to connect.
The Oracle login account.
The password for the Oracle login account.
Allow saving password
If set to true password is stored among the other connection parameters.
After you fill the controls with data click Test connection button to verify
it or click OK button to apply changes and close the dialog.
Advanced Properties dialog box
The Advanced Properties dialog box allows you to specify all properties for the
dotConnect for Oracle connection. Invoke this dialog when connecting to Embedded
server, using secure connections or advanced options such as pooling and Unicode
conversions. The Advanced Properties dialog box appears when you click the Advanced
button on the Add Connection, Modify Connection, or New Database Reference dialog
Design-time integration with project data
Data source wizard
The Data Source Configuration Wizard creates and edits data sources in your application.
These data sources can be made from databases, Web services, or objects, and can
be bound to controls that display data on forms. After you run the wizard, the data
source is available in the Data Sources window for dragging onto forms in Windows
applications. For example, the wizard can generate and add to your project DataSet,
which can be later customized with TableAdapter Configuration Wizard.
You can run the Data Source Configuration Wizard in any of the following ways:
- Choosing Add New Data Source from the Data menu.
- Choosing Add New Data Source from the Data Sources Window.
- Choosing Add New Data Source from the DataSource property of bindable Windows
When wizard starts, choose database as data source type, on the next page click
New Connection button and change data source to Oracle Server, provide logon
information and click OK. After that you will have to choose whether to save sensitive
information together with other parts of connection string in application configuration
file. On the last page of the wizard you select database objects to include in dataset.
On wizard completion you can switch to Solution Explorer to manipulate generated
The TableAdapter Configuration Wizard creates and edits TableAdapters. The wizard
creates TableAdapters based on SQL statements you enter or on existing stored procedures
in the database. The wizard can also create new stored procedures in the database
based on SQL statements you enter into the wizard.
A TableAdapter connects to a database, executes queries or stored procedures against
a database, and fills a DataTable with the data returned by the query or stored
procedure. In addition to filling existing data tables with data, TableAdapters
can return new data tables filled with data.
Using parameterized TableAdapter queries
A parameterized query returns data that meets the conditions of a WHERE clause within
the query. For example, you can parameterize a customer list to display only customers
in a certain city by adding WHERE City = ? to the end of the SQL statement that
returns a list of customers. You create parameterized TableAdapter queries in the
DataSet Designer, or during creation of data-bound forms in a Windows application
with the Parameterize Data Source command on the Data menu. The Parameterize Data
Source command also creates controls on your form to input the parameter values
and execute the query.
Web SQL data source wizard
This wizard is similar to common Data Source Configuration Wizard. To open it from
an ASP.NET Web server control perform the following:
- In Visual Web Developer, create or open an existing .aspx page and then switch
to Design view.
- From the Toolbox, drag one of the server controls that support data binding onto
the page. For example, from the Standard group of the Toolbox, drag a GridView control
onto the page.
- Right-click the control and then click Show Smart Tag.
- In the tasks window, from the Choose Data Source drop-down list, select New data
source. (If there is no drop-down list available in the tasks window, click Choose
Getting more help and information
If you experience problems with using Visual Studio windows related to tasks described
above just press F1 to open Visual Studio documentation.
If you wish to study more detailed the capabilities of Visual Studio integration
you can pay attention to Creating Client Data Applications section in Visual
Studio Help. dotConnect for Oracle provides integration capabilities
similar to standard data providers.