Grid LinqDataSource binding - Foreign key field

[Giancarlo]

Hi,
I have a grid binded to LinqDataSource  (tablename='Region') that show 2 fields "id" and "description".
I want to display also a field "description" of another table ('State') in relathion with the first by stateID Field ( foreign key).
How can I show this last field in my grid?
Thanks a lot to all
Gaetano

[Marin]

Hello,

 If the Region entity also has a property that holds a reference to the related table you can bind the foreign key field through this nested property (e.g. DataField="State.Description"). Otherwise the grid has to be bound to an entity that has all the needed fields that will be shown or you can manually retrieve and set the proper value for the additional description field in the ItemDataBound event. 

Regards,
Marin
the Telerik team

[Giancarlo]

Thank you so much.
"State.Description" field works fine.
Gaetano