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

powered by OSQA