Query data base every minute and get the job ID.Pass the jobId to a WCF service

Posted by Mariannelson under WCF on 11/7/2012 | Points: 10 | Views : 836 | Status : [Member] | Replies : 1
I will explain in steps excatly what I want to my application to do
Step1:-Query data base every minute and my data base table will contain time.If that minute matches the time. Return the JobID
Step2:- Once you get the jobID pass that JobID to WCF service and that will execute certain steps to insert data into data base.

Question 1:-Shall I simple create windows service and using a timer to periodically check the updated data.And pass the job ID to WCF service.

Question 1:-Shall I simple create WCF Client and service where Client will be quering the data base and return the result to WCF Service. Shall I use duplex binding.

Once the jobID is passed to any service to process it will take more then 30 mins. And there will be more then one job running at the same time.


Posted by: Krv on: 11/15/2012 [Member] Starter | Points: 25

It is depends on your requirement
a. If your case is just checking the database for time match and update the database, my suggestion is to go for windows services,
b. If you have clients and need to process more apart from table update, the you can use WCF.

MCTS(SQL Server & BI)

Mariannelson, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response