c# - How to create query of queries using LINQ? -


i'm trying convert query of queries used in coldfusion linq , c#. data come data files, rather database.

i converted first query, have no clue

  1. how use query second query.

  2. how include count(pdate) daycount in second query.

below code using query of queries in coldfusion:

first query <cfquery name="qsorted" dbtype = "query">     select oa, cd,pdate,     dataquery      group cd,oa,pdate,        </cfquery>  second query <cfquery name="qdaycount" dbtype = "query">     select oa, cd, count(pdate) daycount      qsorted   // qsorted first query.                 group      oa, cd     order      oa, cd </cfquery>

here's first converted linq query, , works fine:

var rows = alldata.selectmany(u => u._rows.select(t => new {             oa = t[4],   cd = t[5],   pdate = t[0]               })) .groupby(x => new { x.cd, x.oa, x.pdate  }) .select(g => new {   g.key.oa,   g.key.cd,   g.key.pdate  }) .tolist();

here's pseudo-code second linq query, need assistance:

var rowsdaycount  = rows //is correct? if not, how it? .groupby(x => new { x.oa, x.pdate, x.cd, }) .select(g => new {   g.key.oa,   g.key.cd,   g.key.pdate,//pdate should pdate.distinct().count() asdaycount       // see daycount in cfquery name="qdaycount" above. }) .orderby(u => u.oa) .thenby(u => u.cd)  .tolist();

your second query origionally wasn't grouping on pdate, translation is. that's wrong. if want count number of pdates each oa/cd pair, need not group on pdate. once you've made change, can modify select pull out of pdate values group, , count distinct values.

.groupby(x => new { x.oa, x.cd, }) .select(g => new {     g.key.oa,     g.key.cd,     daycount = g.select(item => item.pdate).distinct().count(), })

Comments

Post a Comment

Popular posts from this blog

android - Inheriting from Theme.AppCompat* -

currently working on migrating actionbar in support libraries. trying migrate old themes inherit theme.appcompat.light.darkactionbar isn't going smoothly. it fine if apply theme in manifest such: <activity android:name="com.fitsby.loginactivity" android:screenorientation="portrait" android:theme="@style/theme.appcompat.light.darkactionbar" > </activity> but runtime error, stating loginactivity(subclass of actionbaractivity) must have theme inherits theme.appcompat, when following: in styles.xml: <style name="apptheme" parent="@style/theme.appcompat.light.darkactionbar"> <item name="android:typeface">sans</item> </style> and in manifest: <activity android:name="com.fitsby.loginactivity" android:screenorientation="portrait" android:theme="@style/apptheme" > </activity> any ideas why happening? not...
Read more

basic authentication with http post params android -

i doing basic authentication passing username , password , using basicnamevaluepair sending post params response service. my method: public stringbuilder callservicehttppost(string username, string password, string type) { // create new httpclient , post header httpclient httpclient = new defaulthttpclient(); httppost httppost = new httppost(webservice + type); httpresponse response = null; stringbuilder total = new stringbuilder(); try { url url = new url(webservice + type); /*string base64encodedcredentials = base64.encodetostring((username + ":" + password).getbytes(), base64.url_safe | base64.no_wrap);*/ string base64encodedcredentials = "basic " + base64.encodetostring( (username + ":" + password).getbytes(), base64.no_wrap); httppost.setheader("auth...
Read more

broadcastreceiver - android BOOT_COMPLETED not received if not activity intent-filter -

Image
i set simple app. wan't hide drawer , want add boot receiver launch service. to hide application, read had remove manifest <intent-filter> <action android:name="android.intent.action.main" /> <category android:name="android.intent.category.launcher" /> </intent-filter> but when remove it, boot receiver doesn't work anymore. i added permission under manifest tag <uses-permission android:name="android.permission.receive_boot_completed" /> and receiver under application <receiver android:name="com.example.receiver.bootreceiver" > <intent-filter> <action android:name="android.intent.action.boot_completed" /> </intent-filter> </receiver> and in receiver code, there toast public class bootreceiver extends broadcastreceiver { @override public void onreceive(context context, intent intent) { toast.maketext(context,...
Read more