'How to show the percentage progress bar in ASP.NET MVC application while executing the stored procedure [duplicate]

I need to show the progress bar or percentage while executing the stored procedure that takes around 4+ minutes to execute.

I have an action from that I am calling a method defined in view model and calling a stored procedure (it will do Insert from table to multiple tables).

Now I have to show in frontend while executing the stored procedure. I saw some Stack Overflow posts, but none worked for me.

  1. I tried using SignalR also but for me I think it will not work for me
  2. I tried background worker but in ASP.NET MVC it affects the pattern
  3. I tried raise error method in the stored procedure too but suggest me how or where to add in-between the insert statement

My flow is

controller -> view model -> stored procedure (execution)

Please give some suggestion or reference.

c++sharpsql-serverasp.net-mvcstored-procedures


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions