To be fair the problem is not with the entity framework, my problem with
EF, is that there seems to be a lack of comprehendable yet informative
documentation, and a lack of decent samples.
The problem is with the grids, that don't really seem to do anything
sensible in this context, I think in general they are too coupled to the
concept of displaying datatables etc, or just a bit poor
e.g. my problem with the datagridview is that the grid tries to use the
formattedvalue of the data to retrospectively look back and work out what
the underlying value is, so in my case the ParseFormattedValue is
failing...the basic problem is the assumption that the displayed string
value can be uniquely and easily mapped back to the underlying
value...which in general is not correct.
I can bodge it....and will have a go, and see what happens.
I do though accept that a value of the EF is considerably undermined by
the lack of vanilla UI elements that can easilz show the data.