This question is locked. New answers and comments are not allowed.
Dear All,
I need to create a custom class to fetch some data, so I implement the following LINQ query:
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
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