i have problem create condition inside linq query (where). condition inside created based on condition. want filter list of indice based on 2 property (id_indice_prix, date_indice). can filter on both of them or one. have suggestion. doing rows database linq entites , if condtion filter based on condition:
var listeindiceactualisationprix = unitofwork.indices_actualisation_prix.tolist(); if (idindiceprix != 0) listeindiceactualisationprix = listeindiceactualisationprix.where(x => x.id_indice_prix == idindiceprix).tolist(); if(annee !=0) listeindiceactualisationprix = listeindiceactualisationprix.where(x => x.date_indice.value.year == annee).tolist();
don't put .tolist() every time. when call .tolist(), query executed. build query dynamically without .tolist(), , @ end of if statements, execute .tolist() query database appropriate where statements.
Comments
Post a Comment