I'm doing a select to calculate present value like this:
.Select("new (Key.t, Sum(cashflow) as profit, sum(cashflow)/power(1+0.04, Key.t) as pv");
I have an error at runtime:
"ExceptionMessage": "No applicable aggregate method 'Power(Double,Int32)' exists"
I also tried C# syntax like this
.Select("new (Key.t, Sum(cashflow) as profit, sum(cashflow)/Math.Pow(1+0.04, Key.t) as pv");
Looks like the syntax might worked? But still an error like this:
"ExceptionMessage": "Operator '/' incompatible with operand types 'Decimal?' and 'Double'"
My query before this is long so I won't bore you. But as a test I know this works for sure:
.Select("new (Key.t, Sum(cashflow) as profit, sum(cashflow)/Key.t as pv");
So it's just the way I'm calling power is having problem.
How to do math power in dynamic linq core?
EDIT: Thanks to @Fildor in the comment I tried
.Select("new (Key.t, Sum(cashflow) as profit, Convert.ToDecimal(sum(cashflow)/Math.Pow(1+0.04, Key.t)) as pv");
but I got
"LINQ to Entities does not recognize the method 'System.Decimal ToDecimal(Double)' method, and this method cannot be translated into a store expression."