HI there,
If I am defining an EditableRoot object type using 1.53 CSLA framework and I have a table with a foreign key. Let's say it's Province table with a parent table relationship, Region. I want to be able to say something like:
Province.Region.Description_English
It appears that the generator in CodeSmithTools (via XML) supports ChildCollection, but this forces going to the next row, which seemed the closed to what I wanted except that it shouldn't move to the next row and it also needs to to a Get() on the key and not the DataReader.
I am wondering if I am missing something to be able to do something as simple as this so that foreign keys are basically interpreted as ParentEntity objects when reading the database. I should never say:
Region.GetRegion(Province.Region("province_id")).Description_English (what a pain that would be!!!)
Thanks,
Brendan