This article saved my day.

I was using .net core and ef 3 to group a table and fetch the first column, unfortunately ef core 3 had broken this feature.

Thanks alot.