I am designing a solution for a client where in data has to be polled from SQL table and a request is to be sent to a WCF service with a request formed from that data. The response of the WCF service will contain additional data that has to be updated in the SQL table again.
For e.g. in TableA there are 6 columns namely primaryKeyColumn,columnA, columnB, columnC, columnD and columnE.
The WCF request will contain data from columns A,B and C.
The service response will contain data for all 5 columns.
The data of columns D and E needs to be updated for that row in the tableA.
I have thought of implementing this using Windows service. To increase the performance I am thinking to implementing multi threading in this solution.
Can some one guide me in this ? I have never used multi threading in windows service before. What are the risks ?
What I have tried:
I have created a windows service that polls the SQL database table every 15 seconds,gets the first row depending on certain condition,create the request for WCF service , call the WCF service, update the data in SQL table based on the response.
I have not implemented multi threading yet.