Windows Service or Console App?
<p>Am quite running out of ideas,</p>

<p>Here is what am trying to do ,
i have two table</p>

<p>TableA and Table B.</p>

<p>TableA has four fields (Cust.No, Cust.Name, Description,FlagCust)</p>

<p>Table B has three fields (cust.No, City,country)</p>

<p>my requirement is check the "<strong>FlagCust</strong>"(its a boolean value) column every 20 mints and if its true then grab the details of the customer from TableA and Table B.</p>

<p>But the problem am facing here is i have to communicate the <strong>DB</strong> thru <strong>WCF</strong> service and this will run every 20 mins periodically.</p>

<p>some of them suggest write a console app and run it in a schedule task,others suggest write windows service to do the job.</p>

<p>Here little bit more after getting those records</p>

<p>once i get the data for example <strong>customer name</strong> and <strong>Description</strong>,in the table A tells about the customer data file and where its located the other upload and download process already i have will go and download the customer file and upload to some other place based on the description details.</p>

<p>And am not sure how to handle the multiple records in this scenario,when its retrieved more than one record for download and upload process.</p>
