Percent complete in C# console app

Question

I've written a C# console application which among other things restores a SQL Server database. It takes a while to restore and I'm wondering if there is a way to display the percentage complete (like it shows when you restore a database manually in the Message pane when STAT is on) in my program console. I understand that if you have multiple tasks rows etc. you can calculate the percent completed based off the number of tasks completed divided by the total number of tasks. The problem is that I only have one task to restore the database.

Mike · Answer

Okay. In that case how can I set it up so it writes a period every 15 seconds? I don't understand how any sort of loop with a sleep timer would work because it would be waiting for the restore to complete.

Jan Montano · Answer

You don't have to be a member to view the public contents of that site. You just have to scroll down below to get some answers. This is one of the accepted solutions: from that link JimBrandley : Since it is not in a loop on your application the query is basically an atomic instruction. However it isn't running on your machine  but on the DB server - your application is idle until it is completed. Then you can use the suggestion I made in my first post; i.e. start a timer just before you call the DB with the query. When it fires increment a cyclic progress bar. That is one that fills from start to end then goes back to empty and does it again. You can stop it when the select returns. Jim To conclude it's really hard to put a timer since this is not a code in y our application. You could just have sort of a marker to tell the user that database restore is still in process. Given that you're using a console app I would just write a period (.) in the console every 15 seconds or so to indicate that the app is still processing. Just my two cents.

Mike · Answer

I'm not a member of that site. Can you paste the content for me please?

Anna Hawks · Answer

http://www.experts-exchange.com/Programming/Languages/C_Sharp/Q_22764547.html