Distinct AsCount error
Opened this issue · 0 comments
WimAtIHomer commented
I have a query with joins and a select distinct for some columns.
The query gives normal results, but when I want to get a count of the query with await query.AsCount().GetAsync();
I get the error: The column 'Id' was specified multiple times for 'countQuery'
Any suggestions how to solve this?