skip to main content
Using the ADO.NET Client : Data Provider Integration Scenario
 

Data Provider Integration Scenario

Because the Open Access SDK for ADO.NET data provider is 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 using Query Builder.
The Query Builder can help you graphically design database queries.
To create a simple query:
1. Establish a data source connection (see Adding Connections).
2. Select the data source in Server Explorer.
3. Right-click Tables; then, select New Query.
4. The Add Table window appears. Select the table that contains the data that you want to use; then, click Add.
5. Click Close to close the Add Table window.
6. Select the columns that you want returned. In this example, we select the id, name, and phone columns of the shippers table.
7. Click the Execute SQL button on the toolbar.
8. Examine the returned results in the Results pane of the Query Builder.