Foreign table properties in Blazor datagrid

Apologies, I am new to Radzen and mainly a SQL developer.

When creating a CRUD page from a table Radzen picks a column to display from the foreign key relationship in the table.
How can you:

  • change the column that is displayed in the datagrid
  • add additional columns
  • expand additional foreign key relations

For example, in a datagrid for Asset display both the Manufacturer.Name and Model.Name for a ModelId in the Asset table.
Asset
(
AssetID
SerialNumber
ModelId
)

Model
(
ModelID,
Name,
ManufacturerId
)

Manufacturer
(
ManufacturerId
Name
)

Hi @dvenardos,

You can use the columns editor. Check also how related columns are defined:

To populate related properties you can use $expand parameter:

1 Like

Thanks @enchev, that works great!