Data Provider Integration Scenario
Because the Pervasive PSQL 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 Using the Pervasive Visual Studio Wizards).
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 salary columns of the employee table.
7
Click the Execute SQL button on the toolbar.
8
Examine the returned results in the Results pane of the Query Builder.