c# - Entity Framework with Include and Select together -


i have following entities ( pseudo code save space)

program [ int id,            string name,            list<programfoodtype> programfoodtypes,            list<programfood> programfoods]  programfoodtype[ int id, int programid, int type, bool isactive] programfood [ int id, int programid, food food, foodtype foodtype] food [int id, string name] foodtype [int id, string name] 

my task single program related programfoodtypes condition programfoodtype should active , programfoods related entities food , foodtype

i used following far

1- below query retrieve details of programfoodtypes , programfoods bring active , inactive programfoodtypes

var program = mentities.programs                           .include(p =>p.programfoodtypes)                           .include(p =>p.programfoods.select(f =>f.food))                           .include(p =>p.programfoods.select( f =>f.foodtype))                           .where(m =>m.id== id); 

2- below query retrieve details missing food , foodtype

var program = (from p in mentities.programs               p.id ==id               select new {                  program = p,                  programfoodtypes = pf in p.programfoodtypes                                     pf.isactive                                     select pf,                                    programfoods = p.programfoods // here can't add include statement               }).toarray().select(m => m.program); 

how include food , food type in second query?

may be:

var program = (from p in mentities.programs           p.id ==id           select new {              program = p,              programfoodtypes = pf in p.programfoodtypes                                 pf.isactive                                 select pf,                                programfoods = p.programfoods.select(y => new {                  food = y.food,                  type = y.foodtype              })            }).toarray().select(m => m.program); 

Comments

Popular posts from this blog

toolbar - How to add link to user registration inside toobar in admin joomla 3 custom component -

linux - disk space limitation when creating war file -