score:2

Accepted answer

use tolist() before groupby and it will work as expected.

filemovementrepository.getall()
                .where(fm => repository.getall().select(f => f.id).contains(fm.fileid) && fm.transferredbyid == userid)
                .include(f => f.user).include(f => f.file).theninclude(f => f.category)
                .orderbydescending(f => f.movedon)
                .tolist()
                .groupby(f => f.fileid)
                .select(f=>f.first())
                .tolist();

Related Query

More Query from same tag