Dropdown values from different tables

Alex_Fatfox · March 5, 2020, 8:02pm

Hi,

I need to display data that is located in different tables but connected via foreign keys. Is there a way to do that?

enchev · March 6, 2020, 7:11am

If you have relationships you can use Include() method to populate related property similar to this demo:
https://blazor.radzen.com/datalist

...
<div>Company:</div>
<b>@order.Customer?.CompanyName</b>
<div style="margin-top:20px">Employee:</div>
<b>@(order.Employee?.FirstName + " " + order.Employee?.LastName)</b>
....
IEnumerable<Order> orders;

protected override void OnInitialized()
{
   orders = dbContext.Orders.Include("Customer").Include("Employee").ToList();
}