LINQ query returning a List<> as a class member -


given follow data class,

 public class employeemenu  {   public int id { get; set; }   public string headername { get; set; }   public list<string> itemnames { get; set; }  } 

how can sub-query itemnames field?

my current query of

 iqueryable<employeemenu> retvalue =   mh in menuheaders   select new employeemenu   {    id = mh.id,    headername = mh.headername,    itemnames = (from mhi in mh.menuitems        select mhi.menuitemname).tolist<string>()   }; 

doesn't seem doing trick...

the data structure

menuheaders        menuitems -----------        --------- id                 id headername <-(fk)--menuheaderid                    menuitemname 

i ended changing list ienumerable. fixed it.


Comments

Popular posts from this blog

android - Spacing between the stars of a rating bar? -

aspxgridview - Devexpress grid - header filter does not work if column is initially hidden -

c# - How to execute a particular part of code asynchronously in a class -