Loading

lambda expression with sum and where condition

Sushant Torankar

hello,

I want to calculate total filesize of user, using lambda expression with SUM and WHERE condition, but it;s giving some parse error

FileSize column is of datatype DOUBLE. Following is my code :

var total = await _context.LogsMasters.Where(p => p.UserId == Id).Sum(p => p.FileSize);

return total;

how to achieve that or any other wayt to get it?

I can get that total using store procedure, but I want to go with entity framework code directly

thank you

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sushant Torankar4y ago
thank you sachin for reply
But it's not working , it says - double? does not contain defination for "GetAwaiter" accepting first argument of type double? could be found (are you missing directive or assembly reference)
Sachin Singh4y ago
Test this
var total = await _context.LogsMasters.Where(p => p.UserId == Id).ToList().Select(x=>x.FileSize).Sum();