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

Percent complete in C# console app

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (4)