c# - Execution of 'System.Linq.Enumerable:GroupBy(IEnumerable`1,Func`2)' on the database server side currently not implemented -

i getting error 'execution of 'system.linq.enumerable:groupby(ienumerable`1,func`2)' on database server side not implemented.' when execute following query

from t in dbcontext.trackerrecords    t.deviceserial.value.equals(deviceserial) &&    t.date.value >= fromdate && t.date.value <= todate    orderby t.date.value descending    group t t.date.value.date g    select new tripdatamodel    {       day = g.key,       trips = (from x in g          group x x.date.value.hour gj          gj.max(m => m.speed.value) > 0          let avgspd = gj.average(m => m.speed.value)          select new tripmodel          {             minspeed = gj.min(m => m.speed.value),             maxspeed = gj.max(m => m.speed.value),             avgspeed = avgspd > 0 ? math.round(avgspd, 2, midpointrounding.awayfromzero) : 0,             fromhour = new datetime(g.key.year, g.key.month, g.key.day, gj.key, 0, 0)          })    } 

i tried query in linqtosql , working fine need use telerik openaccess
there solution or workaround this?

http://www.telerik.com/forums/server-side-currently-not-implemented

after first query, convert list, run subquery.

like this:

from t in dbcontext.trackerrecords.tolist() 

then, rest of query.