MVC Progress Bar while loading DB data in HomeController() before Index ActionResult is hit C#

Question

I have HomeController which loads data to model from SQL DB.

Before the:

public ActionResult Index()
    {
        return View(_homePageViewModel);
    }

is hit, the data is loaded to

_homePageViewModel

and when it is ready the Razor Page is being loaded.

I have managed to show Loading GIF while Razor Page's content is being loaded, but there is some time before it that nothing is shown, it's when the HomeController's main constructor loads data from DB.

I need to show progress bar that will go from 0% to 100% while loading data from the DB.

I don't know how to achieve as the Index Page is not loaded yet.

Do I need to load loader page before the Index is rendered? Just to cover the time HomeController finishes it's work?

JotaBe · Accepted Answer · 2019-06-17 13:40:57Z

1

You need to create a "loader page", as you call it, that uses AJAX to update its contents. However there is no way to measure and show the % in the page: there isn't something like a "db query completion percentage" that you can use.

The loader page could:

show some kind of spinner GIF
use an AJAX call to
- get the relevant data (uisng web API) and render the HTML with javascript
- get a partial page (using MVC), and include it in the loader page DOM

answered Jun 17, 2019 at 13:40

JotaBe

39.3k9 gold badges102 silver badges121 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MVC Progress Bar while loading DB data in HomeController() before Index ActionResult is hit C#

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related