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