Datagrid lookup non related Table

I have been going round in circles here.
How do i get the text value form a lookup table to display in a datagrid when the two tables are not related? You may ask why they are no related but i do not have control of this database so i can't make the change.

i've tried ading a LINQ query in a partial class but i'm not getting anywhere. Do you have some worked examples i can follow?



This article shows how to extend your model with additional property that can be populated from anywhere:


this is one of the reasons I like this software so much, because you guys are so quick to respond.

Many thanks


1 Like