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

Popular posts from this blog

java - How to set log4j.defaultInitOverride property to false in jboss server 6 -

c - GStreamer 1.0 1.4.5 RTSP Example Server sends 503 Service unavailable -

Using ajax with sonata admin list view pagination -