score:0

Accepted answer
var a = 123; 
var sum = (from p in a where p.id == a) //gives 10 records. 
             .sum(x => int.parse(x.balance));

var sum = (from p in db.table where p.id == a)
             .asenumerable() // @juharr's suggestion
             .sum(x => convert.toint32(x.balance));

score:0

var sum = (from p in db.table where p.id == a)
             .tolist()
             .sum(x => convert.toint32(x.balance));

Related Query

More Query from same tag