c# - Change the alias column name with a variable -
c# - Change the alias column name with a variable -
i'm still beginner in asp.net , wanted know if there's way pass variable column name(alias) select in linq. want way gain flexibily using linq. reading request
date|idcourrier|sens var req = courrier in db.elise_stat_courriers select new { date =dbfunctions.truncatetime(courrier.datecourrier).tostring().substring(0,10), courrier.idcourrier, courrier.sens, }; list<string> l = new list<string> { "arrivé", "départ", "dossier", "interne" };
those column names , if it's possible pass them variable
date|arrivé|départ|dossier|interne var req1 = courrier in req grouping courrier courrier.date grp select new { date = grp.key, l.elementat(0)= grp.where(x => x.sens=="arrivé").count(), l.elementat(1)= grp.where(x => x.sens == "départ").count(), l.elementat(2) = grp.where(x => x.sens == "dossier").count(), l.elementat(3)= grp.where(x => x.sens == "interne").count() };
this eror : invalid anonymous type fellow member declarator. anonymous type members must declared fellow member assignment, simple name or fellow member access.
c# asp.net linq
Comments
Post a Comment