QuickGrid executes the same query twice when prerendering and rendering interactively

[danroth27]

QuickGrid will execute the same query twice when prerendering and rendering interactively.

Repro steps:

• Create a default Blazor Web App
• Run the Blazor CRUD scaffolder to add a QuickGrid set up to use EF Core
• Update the Index page with the QuickGrid to use interactive server rendering
• Run migrations to setup the DB and then run the app and browse to the Index page with the QuickGrid
• Examine the app logs to see the duplicate queries: one for when the page prerenders and one for when the page renders interactively.

@javiercn Could we use the persistent component state infrastructure to avoid the duplicate query?

[javiercn]

@danroth27 yep, that would be ideal.

[javiercn]

I think we can't easily do this without doing it inside quick grid. The reason is that quickgrid receives an IQueryable instance, which is not something that we can serialize on the consuming component.

I think what we want is to extend quickgrid to have a flag for persisting the query results on the server, restore that internally and trash it the moment the user interacts with the grid.

I'm moving this to 11.0 based on that