Adding a SQL Statement Operation Using SQL Dialog

Use the SQL Dialog to create select, insert, update, and delete statements.

Select the Service Interface page in the database service editor.
Specify a database as an endpoint for the operations of the interface for this service. From the Enterprise Explorer, drag the database connection profile for your database onto the interface box in the service diagram.
This creates the endpoint for the operation.
Note
If you insert a SQL statement operation without specifying a database, you must modify any generated parameters or result sets, and/or provide parameters or result sets by entering them manually in the parameters dialog at deploy time.
Right-click the interface box and select Add SQL Statement Operation|Add Request-Response Operation from the menu.
This adds a default operation to the interface.
Expand the Properties panel and click the Source tab.
Click New in SQL Dialog....
The Select Statement Type dialog appears.
Select a statement type and click OK.
The SQL Dialog Select Tables dialog appears.
Select tables and click Open.
The SQL dialog appears.
Click OK when you are finished.
You can now edit the SQL statement manually or in the SQL Query Editor.