Orderby after groupby

javier

I have a query that I'm using to group the records.

tblAgentActivities
.Where (aa => aa.StartDate >= DateTime.Today)
.OrderBy (aa => aa.AgentActivityID)
.GroupBy (aa => aa.tblUser.FullName)
.OrderBy (aa => aa.Key)

When I run this, I get a bunch of nested tables grouped by "FullName", which is what I want. But I want to be able to sort those tables by AgentActivityID, which I can't.

javier

Sorry, forgot the actual question..

Is there a way to sort the grouped tables?

Puf

http://stackoverflow.com/questions/21704482/how-do-i-order-by-after-grouping

javier

Thanks, that's actually me. I'm still wondering if there's a way to use the native functionality of linqpad rather than side-stepping it.

JoeAlbahari

Yes, there is. See my answer on SO.

javier

Joe, great answer, and you are 100% correct, I'm using linq to entities.