gistfile1.txt

GLEntity

KeyGuid Guid
EntityID String


ConsolHeader

KeyGUID Guid
TableID string
ConsolEntity FK to GLEntity.KeyGUID


ConsolDetail

KeyGUID Guid
ConsolHeader FK to ConsolHeader.KeyGUIT
Entity       FK to GLEntity.KeyGUID (this would be a child)
Pct float

The relationship is

GLEntity 1 - to - 1 ConsolHeader 1 - to * ConsolDetail

I want to be able to access to ConsolDetails as a navigation property on GLEntity so I don't need to do...

GLEntity.ConsolHeader.Single().ConsolDeatail etc.

For some reason I thing in our EF model GLEntity is 1 to * with ConsolHeader but it shouldn't be.