DataDirect Connect for ADO.NET Data Provider Help

Use Scenarios for Data Provider Integration in Visual Studio

Save PDF

Use Scenarios for Data Provider Integration in Visual Studio

Save PDF

Last Updated: April 16, 2026
3 minute read

ADO.NET
Documentation

Because DataDirect Connect for ADO.NET data providers are integrated into Visual Studio, many typical data access tasks can be simplified. For example, after making the connection to the database, you can create queries and update the database using Query Builder.

The following scenarios are only a few of the ways you can take advantage of this integration:

Creating a Simple Query
Inserting Data Into a Table

Creating a Simple Query

The Query Builder can help you graphically design database queries.

To create a simple query:

Establish a data source connection (see Creating a New Connection in Server Explorer).
Select the data source in Server Explorer. Then, right-click Tables and select New Query. The Add Table window appears.
Select the table that contains the data that you want to use; then, click Add.
Click Close to close the Add Table window.
Select the columns that you want returned. In this example, we select the LastName, FirstName, and Title columns of the Employees table.
Click the Execute SQL button ( ) on the tool bar.
Examine the returned results.

Inserting Data Into a Table

You can connect to the database and use Query Builder to insert data into a table.

To insert data:

Establish a data connection (see Creating a New Connection in Server Explorer). Then, expand the data connection in Server Explorer.
Right-click Tables; then, choose New Query. The Add Table window appears.
Select the table that contains the data that you want returned, then click Add. In this example, we select DEPT_TMP.
Click Close to close the Add Table window.
Select the Change Type button on the tool bar; then, select Insert Results from the drop-down list.
Insert data in the DEPT_TMP table by entering new values. The following example adds a new department name, Marketing, and department number, 7.
Click the Execute SQL button on the tool bar. One row is added to the table.
Select the Change Type button on the tool bar, and choose Select from the drop-down list.
Click the Execute SQL button . The results are returned in the Results pane. In the following example, the Marketing department has been added to the DEPT_TMP table.