syncfusion blazor grid entity framework database scaffold tutorials
How to Build a Blazor WebAssembly CRUD Application with Entity Framework and Syncfusion, https://www.syncfusion.com/blogs/post/how-to-build-a-blazor-wasm-crud-application-with-entity-framework.aspx
Scaffolding Syncfusion Controls in Blazor Applications, https://www.syncfusion.com/blogs/post/scaffolding-syncfusion-controls-in-blazor-applications.aspx
How to Build a Blazor CRUD Application with Dapper and Syncfusion, https://www.syncfusion.com/blogs/post/build-blazor-crud-application-with-dapper.aspx
Syncfusion Blazor Scaffolding, https://help.syncfusion.com/extension/blazor-extension/visual-studio/scaffolding and https://blazor.syncfusion.com/documentation/visual-studio-integration/visual-studio-extensions/scaffolding
Once you've gone through the first three tutorials, which sheds light from different angles, few things that helped me further:
I struggled how to consistently move connection string from dbcontext to appsettings, but this helped me, https://stackoverflow.com/questions/45796776/get-connectionstring-from-appsettings-json-instead-of-being-hardcoded-in-net-co
But from this site, specifically the code:
IConfigurationRoot configuration = new ConfigurationBuilder()
.SetBasePath(AppDomain.CurrentDomain.BaseDirectory)
.AddJsonFile("appsettings.json")
.Build();
optionsBuilder.UseSqlServer(configuration.GetConnectionString("DefaultConnection"));
The above code comes in the DbContext file created when "Scaffold-DbContext" was created in the first and second tutorial, where the connection string is explicitly stated. The connection string is then moved to appsettings.json and registered in Startup.