How to add a column to display related data

[Patrick]

I'm sure there's already an answer to my question in the forum, but I haven't been able to locate one:

In a WinForms project I'm using an entity framework entity that represents a table of invoice data: Project_ID, Principal, Interest, etc. Since I'm using an entity representation of a table, it doesn't include, in this case, the ProjectName located in the projects table.  I want my grid to be based on the entity to use the framework's functionality to update the table, but I want a column next to the Project_ID that displays the related ProjectName.  How can I accomplish this?

Thank you in advance for your help.

Patrick

[George]

Hello Patrick,

Thank you for writing.

Since you want to use all the functionality of EntityFramework It seems that your best option is to edit either your Model or your Database schema, which will update the Model and vice versa. This way you will be able to bind to the same Model, however it will have the properties you need and the functionality of EntityFramework.

I hope this helps.

Regards,
George
Telerik

[Patrick]

Thank you for the suggestion.  The only other thing I had thought of was adding a call in the CellFormattng event to get the related data and populate a manually added column. But that would be a lot of trips to the database.  I added a entity to the model that represents a view that included the related data.  It works nicely and I can map CRUD functionality to the entity. Thanks again.

[George]

Hi Patrick,

I am glad that you found a solution for your case. Should you have any further questions, do not hesitate to contact us.

Regards,
George
Telerik