Combine/Join two tables in datagrid?

[Micke]

Hey, Im new to both C#, blazor and Radzen

I need to combine data from two different database tables in one single datagrid. Using a database view is not an option ( as far as I know) since the user should be able to edit and save changes to one of the tables. How do I achieve a join between two tables in radzen the easiest way?

[enchev]

@Micke

Using a database view is not an option ( as far as I know) since the user should be able to edit and save changes to one of the tables

You can always use stored procedures to save changes in such case.