Hi everybody,

I'm thinking what would be the best way for the following scenario.

I have the Sales Channel table and a related table called ScSgLink, where Sg stands for sales points group and has a link to the Sales Points Groups.

I implemented this for the GetById in that SChannels Repository:

 public override SChannels GetById(object id)
        {
            var sChannel = _siriusContext.SChannels.Include("ScsgLink")            
             
             .Where(x => x.ChannelId == (Int32)id)
             .First();


            return sChannel;
        }

That correctly returns collection of the ScSgLink objects.

My problem is that I want to also show group description which is in another table.

My current EditViewModel has the following:

  public int ChannelId { get; set; }
        
        [Display(Name = "descrip", ResourceType = typeof(Labels))]
        public string Descrip { get; set; }
        
        public string CUdf1 { get; set; }
        
        public string CUdf2 { get; set; }
        
        public bool Hidden { get; set; }

        //public System.Collections.Generic.ICollection<Siriusware.Models.Max4Sale> Max4Sale { get; set; }

        public System.Collections.Generic.ICollection<Siriusware.Models.ScsgLink> ScsgLink { get; set; }

I need to somehow display the group description in the interface and here I am not sure of the good way to implement it.

I can create another class to add description and use that class in the ICollection or I can add the GroupDescription to the ScsgLink class (as a partial class with that new property).

The problem is that I don't know exactly how to retrieve it. Assuming I've added GroupDescription property to the ScsgLink class how should I modify the GetById method to grab it as well? It is coming from the SpGroup table (

public int GroupNo { get; set; } // group_no (Primary key). Primary key
        public string Descrip { get; set; } // descrip)

Thanks in advance.