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's gravatar image


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 Dmitri%20Maximov's gravatar image

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 TimM's gravatar image

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


(Nov 14 '11 at 07:19) Dmitri Maximov Dmitri%20Maximov's gravatar image
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


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



Asked: Nov 14 '11 at 06:43

Seen: 5,416 times

Last updated: Nov 14 '11 at 07:19

powered by OSQA