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
Post a Comment