i plan join 2 table, , distinct value of language column. how should achieve in linq? try add 'group' no luck. besides, want select s value r distinct language value.
my code:
public actionresult questionlink(int survey_id) { var query = r in db.surv_question_ext_model join s in db.surv_question_model on r.qext_question_id equals s.question_id s.question_survey_id == survey_id group r.language << not work ** select r; return partialview(query.tolist()); }
this in morelinq called distinctby
. if method works on ienumerable
, can't use in ef query. can use same approach:
var query = r in db.surv_question_ext_model join s in db.surv_question_model on r.qext_question_id equals s.question_id s.question_survey_id == survey_id group new { r, s } r.language grp select grp.firstordefault();
but wonder if want. result depends on ordering of languages database happens return. think should add predicate specific language , remove grouping:
var query = r in db.surv_question_ext_model join s in db.surv_question_model on r.qext_question_id equals s.question_id s.question_survey_id == survey_id && r.language == somevariable select new { r, s };
Comments
Post a Comment