>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.