Blazor Grid FROMSQLRAW Storedprocedure

Question

Hi all,I was hoping you could show me a sample where the grid has autogenerated columns from a stored procedure returning a set of data that is not aligned with a specific entity.The stored procedure should join related tables together to show composite data.  For example, SELECT p.name, p.DOB, g.genderName as gender FROM person.p LEFT JOIN gender g ON p.genderId = g.genderId WHERE p.personId = @PersonIDI am using EF Core 5.Thank you in advance!

Jeevakanth Palaniappan · Accepted Answer

Hi Andrew, 

Greetings from Syncfusion support. 

We suggest you to refer the below documentation on the sql server data binding and auto generated columns. As similar to the documentation we suggest you to invoke the sql queries(stored procedure) in the Custom Adaptor’s Read/ReadAsync method. 

https://blazor.syncfusion.com/documentation/datagrid/columns/#auto-generation 
https://blazor.syncfusion.com/documentation/datagrid/data-binding/#sql-server-data-bindingsql-client 
https://blazor.syncfusion.com/documentation/datagrid/custom-binding/#custom-binding 
https://blazor.syncfusion.com/documentation/datagrid/custom-binding/#data-binding 

Please get back to us if you have any other queries. 

Regards, 
Jeevakanth SP.