EF Core related data causing error in SfGrid

[Richard Rooks]

The grid fails to initialize when creating a column as such:

               <GridColumn Field=@nameof(User.Employer.Name) HeaderText="Company" TextAlign="TextAlign.Left" Width="100"></GridColumn>

the data is loaded as shown:

_users = userDb.Users.Where(u => 1 == 1).Include(c => c.Employer).ToList();

the c.Employer is defined in the User class as:

public Company Employer { get; set; }

When I debug and view the _users variable it is full of data for the Employer but the grid does not like it.

Thoughts?

Thanks Richard

[Renjith Singh Rajendran]

Hi richard, 

 

Greetings from Syncfusion support. 

 

We suggest you to refer to the below documentation for more details regarding binding Complex data column to Grid. 

https://blazor.syncfusion.com/documentation/datagrid/columns/#complex-data-binding 

Please get back to us if you need further assistance.  

Regards, 

Renjith R 

[Richard Rooks]

<GridForeignColumn Field=@nameof(User.CompanyId) HeaderText="Company" ForeignKeyValue="Name" ForeignKeyField="Id" ForeignDataSource="@_companies" Width="150"></GridForeignColumn>

That did the trick. Thanks. It would also be helpful if there was a reference to this when one wants to use EF Include statements so that your users don't get frustrated that the grid cannot use user.comapny.name, which to me would be an intuitive way for it to work.

Richard

[Renjith Singh Rajendran]

Hi richard, 

Thanks for your update. We are glad to hear that your requirement is achieved.  

We would like to inform you that we have already documented the ForeignKey column feature topic in Grid. Please refer the below documentation for more details, 

Documentation : https://blazor.syncfusion.com/documentation/datagrid/columns/#foreign-key-column 

Online demo : https://blazor.syncfusion.com/demos/datagrid/foreign-key-column?theme=bootstrap4 

 

Please get back to us if you need further assistance. 

Regards, 

Renjith R