Select net value from sum of 2 columns in linq

Farhan Ahmed6y ago

https://entityframework.net/knowledge-base/10239987/get-sum-of-two-columns-in-one-linq-query-without-grouping

https://www.csharp-examples.net/linq-sum/

Navaneeth Krishnan6y ago

https://stackoverflow.com/questions/641682/linq-to-sql-sum-without-group-into

Jaimin Shethiya6y ago

Hello siva,

try to below query

var totCurrentQty = context.TableName.Sum(x=> x.CurrentQty ?? 0);
var totNewQty = context.TableName.Sum(x=> x.NewQty ?? 0);

Thanks

Jignesh Kumar6y ago

Hi Siva Nathan,

Please use below link which will help you,

https://entityframework.net/knowledge-base/52404747/calculating-the-difference-between-two-column-with-null-s-using-entity-framework