This should work:
using (var Context = new RechargeEntities())
{
var Que = Context.AirtimePromoTables
.Sum(b => b.Amount);
}
[EDIT]
You don't need to check whetever
amount
is null or not. You don't even need to convert nulls to zeros to be able to sum it up, because
Enumerable.Sum Method (IEnumerable(Nullable(Double))) (System.Linq)[
^] accepts nullable values as an input parameter.
So, using:
.Sum(b => b.Amount!=null ? b.Amount : 0);
is redundant!
Check this:
double?[] amounts = {null, null};
var result = amounts.Sum();
or
double?[] amounts1 = {null, 2.5, 1.5, 0.5, 0.25, 1.75, 3.0, null};
var result1 = amounts.Sum();
Good luck!