Re: EF 6 GroupBy NullReferenceException

[Eugen Khudoliiv]

Yeah, sorry, I missed the orderby stmt, now examples should look like these:

var finalActivities = from examActivity in activitiesFilteredForReport
orderby examActivity.CreateTime descending
group examActivity by axamActivity.CreateTime into gr
select gr.FirstOrDefault();

I can't show SQL for this query, cause it fails even I call 'ToString()'

But if I write code like this:

var finalActivities = from examActivity in activitiesFilteredForReport
orderby examActivity.CreateTime descending
group examActivity by axamActivity.CreateTime into gr
select gr.FirstOrDefault().Id;

It gives me Ids without any exception.