Step 1 : Design Services

First of all, you have to design the service flow and the function of what this service does. So, the main goal of our service is to retrieve the information from the stored procedure. 

Service: Retrieving the information from the stored procedure

After you know that you have to create the service. So, you can fully concentrate on designing how your service functions including. See more details at Step 1: Design Services

  • Service descriptions
  • Interface structure
  • Service flow and external systems integration

Design Service

This part will design the service that includes what the function is and describe the details.

Service Description :
Service name : testsp
Description : retrieve data from stored procedure
Project : testservices

Interface Structure:
This service does not have the interface structure because the function is for retrieving data from stored procedure only.

Service flow and external systems integration:
Database : MSSQL
Database : Name testdp
Database : Table Selecttea3

Design service flow

This part will design the function of the service into the flow diagram.

Service flow