This is a migrated thread and some comments may be shown as answers.

SUM of related table fields

4 Answers 111 Views

LINQ (LINQ specific questions)

This is a migrated thread and some comments may be shown as answers.

This question is locked. New answers and comments are not allowed.

Ubuntu asked on 24 May 2011, 11:02 AM

Dear All,

I need to create a custom class to fetch some data, so I implement the following LINQ query:

var dailys = (from Summary in DataContext.summeries

join Period in DataContext.Periods on Summary.periodid equals Period.periodid

where

&& Summary.date >= Period.from

&& Summary.date <= Period.to

select new dailysummaryview

{

period = Summary.periodid,

month = Summary.month,

total_x = Summary.dailies.Sum(k=>k.x),

total_y = 8 //Summary.dailies.Sum(k => k.y)

});

return dailys;

I always get the exception of :
Result type calculation: expected FieldNode, FieldNavNode, LiteralNode, AggregateNode, BinaryNode, ParamNode.

If I change the total_x to total_x = constant like total_y I got no exceptions.

What solution could be for that issue... anyboady knows.
Regards

SUM of related table fields

4 Answers, 1 is accepted