c# - groupby filtering in linq -


i need groupby query

if (randomize) {     list<tblinvoice> _result = db.tblinvoices.tolist();      var _temp = xxx.where(p => (p.ispostalpayment == null || p.ispostalpayment == false)).tolist();     _result = _temp.orderby(o => guid.newguid()).take(5).tolist();     _result = _result.groupby(x => x.cuserid).tolist();     return _result; } 

when use groupby in query, error when use groupby in query, under error

cannot implicitly convert type 'system.collections.generic.list>' 'system.collections.generic.list'

the type of _result list<tblinvoice>. here

_result = _temp.orderby(o => guid.newguid()).take(5).tolist(); 

you have no problem. order invoices , take 5 of them create new list<tblinvoice>.

however, here

_result = _result.groupby(x => x.cuserid).tolist(); 

there problem. groupby return sequence of igrouping<tkey,telement> objects , calling tolist create list of type of objects , not list<tblinvoice>. can't assign reference of list of type variable can hold references list<tblinvoice> objects.


Comments

Popular posts from this blog

sublimetext3 - what keyboard shortcut is to comment/uncomment for this script tag in sublime -

java - No use of nillable="0" in SOAP Webservice -

ubuntu - Laravel 5.2 quickstart guide gives Not Found Error -