Hi guys. Another View thing. Because I need to use a View for my datagrid, there's no way I can use 'expand' or access the inferred table relationships to access related table data. On a normal table, I can do this (flattening out junction table data) which works fine -
${string.Join(", ", data.SubsidyTypesJunctions.AsEnumerable().Select(a => a.SubsidyType))}
But, because I'm forced to use a View, I have to do this -
${string.Join(", ", getSubsidyTypesJunctionsResult.Where(a => a.PropertyFK == data.PropertyID).AsEnumerable().Select(b => b.SubsidyType))}
Which runs fine, but makes the whole datagrid blank in design. No rows, columns, anything. Obviously, this makes the datagrid very difficult to work with. My question is, is there a trick or another way of doing this to make the datagrid happy and display propertly during design time?
Thanks again,
SloSuenos