This Blazor stuff is very new to me. Old Desktop app dev here.
I want the real basics of how you connect to a MS SQL DB. I have a SP that takes a parameter and returns a number of columns.
I have a grid on a razor page and it works when I hardcode the data within the page.
I now want to connect to my DB and use the data it returns.
I created the DBContext. Has the connectionstr and the dbSet and the class describing the resultset.
Not sure how to connect to the SP or get that attached to the data grid. I want the result to feed the columns to the grid.