get the sum of column using Entity framwork

Fares Ayyad

9y1.1k.NET

Hello

i want to implement the following SQL statement using entity framework:

select coalesce(SUM(cdin_ActMortgageAmnt),0) from CRM.dbo.CDIndex,CRM.dbo.company where comp_companyid=cdin_companyid and comp_idcust like '%10319%' and cdin_Deleted is null and cdin_startunstufdate is not null and cdin_Status='InProgress'

i tried to get the sum of cdin_ActMortgageAmnt

but the query gives me null while tracing?

3 Replies

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

Bikesh Srivastava9y ago
use like this.
unitOfWork.deviceInstanceRepository.Get()
          .GroupBy(w => new
          {
              DeviceId = w.DeviceId,
              Device = w.Device.Name,
              Manufacturer = w.Device.Manufacturer,
          })
          .Select(s => new
          {
              DeviceId = s.Key.DeviceId,
              Name = s.Key.Device,
              Manufacturer = s.Key.Manufacturer.Name,
              Quantity = s.Sum(x => x.Quantity)
          })
Manas Mohapatra9y ago
In SQL statement it is doing Cross-join but linq is doing inner join. Please verify which one is correct.. May be linq result is null based on join and filtering..
Krishna Rajput Singh9y ago
Hello Fares Thank you for writing below links hope helpful for you....:)

http://stackoverflow.com/questions/19027469/entity-framework-sum-performance

https://damieng.com/blog/2014/09/04/optimizing-sum-count-min-max-and-average-with-linq

https://social.msdn.microsoft.com/Forums/en-US/fdb2ff01-e2e3-4cb4-9778-65941e59c092/entityframework-can-sum-without-grouping?forum=adodotnetentityframework

if find helpful answer mark as correct answer