select multiple columns using linq and sum them up
- by Yustme
Hi,
How can i select multiple columns and calculate the total amount.
For example, in my database i got a few fields which are named:
5hunderedBills,
2hunderedBills,
1hunderedBills,
etc.
And the value of those fields are for example:
5,
2,
3
And the sum would be:
5hunderedBills * 5 + 2hunderedBills * 2 + 1hunderedBills * 3
How can i do that with LINQ in one select statement?