RadzenTree binding to model w/ foreign key children

Radzen Blazor Studio
1

I'd like to use parent-child tables from my sqlite model as some kind of expandable list. i tried using a grid:

  		<RadzenDataGrid TItem="Seed.Models.College_Scorecard.Question"
  										KeyProperty="Id"
  										AllowPaging="false"
  										AllowSorting="true"
  										AllowFiltering="true"
  										AllowColumnResize="true"
  										AllowGrouping="true"
  										HideGroupedColumn="true"
  										AllowRowSelectOnRowClick="false"
  										Density="Radzen.Density.Compact"
  										Data="@questions">
  			<Columns>
  				<RadzenDataGridColumn Title="Category"
  															Property="Category1.Title"
  															TItem="Seed.Models.College_Scorecard.Question">
  					<Template Context="data">
  						@categories.FirstOrDefault(c =>
  														c.Id == data.Category)?.Title
  					</Template>
  				</RadzenDataGridColumn>

  				<RadzenDataGridColumn Title="Included"
  															Property="Included">
  					<Template>
  						@*
  						<RadzenCheckBox />
  						*@
  					</Template>
  				</RadzenDataGridColumn>


  				<RadzenDataGridColumn TItem="Seed.Models.College_Scorecard.Question"
  															Property="Title"
  															Title="Title" />
  			</Columns>
  		</RadzenDataGrid>

... but gave up thinking that grouping/collapsing would be too hard to code. So then i'm thinking of a tree component; but can't seem to bind it properly:

  		<RadzenTree Data="@categories"
  								ChildrenProperty="Questions"
  								AllowCheckParents="false"
  								SingleExpand="true">
  			<RadzenTreeLevel>
  				<Template>
  					<RadzenStack>
  						<!-- Display Title if available -->
  						<RadzenLabel Text="@context?.Title" />
  						<RadzenButton Text="Play" Click="@(args => Play(context))" />
  					</RadzenStack>
  				</Template>
  			</RadzenTreeLevel>
  		</RadzenTree>

... attached is the diagram from the sqlite table, can you advise on how to bind this so that root nodes show Category.Title and children show Question.Title... and have it ordered by Category.Weight,Question.Title?
2024-10-31_140329

2

You should use hierarchy not grouping for the DataGrid:

Here also database relations demo with Tree component: