Query fails: "Cannot perform an aggregate function on an expression containing an aggregate or a subquery."

One of my LINQ queries fail with a Syntax Error and the message : "Cannot perform an aggregate function on an expression containing an aggregate or a subquery."

I'm using MS SQL Server 2008 R2 and DO 4.4.

You can find the LINQ code @ here

asked Nov 14 '11 at 06:43

TimM
9●7●7●9

Hello TimM,

Could you please provide us with the resulting SQL? As I understood, the exception occurs on SQL Server side during the command execution. But if there is a chance, it would be great to get a sample that fails so we could thoroughly investigate the query translation.

Thanks in advance.

(Nov 14 '11 at 07:14) Dmitri Maximov

Sample would be hard at the current time (lacking the time at the moment) but I could give you the full exception (including the 'query' it produced).

Just tell me where to send it to (email, ...)

(Nov 14 '11 at 07:17) TimM

Please, send it to support@x-tensive.com

Thanks.

(Nov 14 '11 at 07:19) Dmitri Maximov

Be the first one to answer this question!

Please start posting your answer anonymously - your answer will be saved within the current session and published after you log in or create a new account. Please try to give a substantial answer, for discussions, please use comments and please do remember to vote (after you log in)!

toggle preview

community wiki

Subscription:

Once you sign in you will be able to subscribe for any updates here

Tags:

bug-report ×120
bug ×10
sqlserver ×9
query-translation ×8

Asked: Nov 14 '11 at 06:43

Seen: 7,663 times

Last updated: Nov 14 '11 at 07:19

Subscription:

Related questions