>Is there a navigation property from your ScgsLink to your SpGroup? If not, there should be. Then you won't need a GroupDescription property in ScgsLink, since you can just use scsgLink.SpGroup.Descrip. Your query also remains simple as:
>
>public override SChannels GetById(object id)
> {
> var sChannel = _siriusContext.SChannels.Include("ScsgLink")
> .Include("ScsgLink.SpGroup")
> .Where(x => x.ChannelId == (Int32)id)
> .First();
>
> return sChannel;
>}
Thanks a lot, Rob. I'll try that out later.
If it's not broken, fix it until it is.
My Blog