not able to getting Sum Result when Group by using LINQ

Question

Here I'm Writing simple Group by Class as

public IQueryable<Banker_Outward_Lock> GetcommedityDetails(string inwardreceipt)
{
    var x = from n in _Context.tbl_Commodity_Overview
            join _lock in _Context.tbl_bank_material_lock on n.co_user_registration_id equals _lock.bm_farmer_registration_id.ToString()
            where n.co_receipt_number == inwardreceipt
            group _lock by new { n.co_total_inward_quantity, n.co_balance_bags,_lock.bm_quantity,_lock.bm_No_Bags } into g
            select new Banker_Outward_Lock
                {
                    Quantity=g.Key.co_total_inward_quantity,
                    No_Bags=g.Key.co_balance_bags,
                    Locked_Qty=g.Key.bm_quantity,
                    Locked_Bags=g.Key.bm_No_Bags,
                    Balance_Qty=g.Sum(_lock=>_lock.bm_quantity),
                    Balnce_Bags=g.Sum(_lock=>_lock.bm_No_Bags),
                };

    return x;
}

This is my Sql Query which runnning fine

select n.co_receipt_number, n.co_total_inward_quantity, SUM(lock.bm_quantity) As Locked_Quantity, n.co_balance_bags, SUM(lock.bm_No_Bags) as lockedBags,
    SUM((n.co_total_inward_quantity) - (lock.bm_quantity)) as Balanced_Qty
from tbl_Commodity_Overview as n
JOIN tbl_bank_material_lock as lock on n.co_user_registration_id = lock.bm_farmer_registration_id
where co_receipt_number='KSWC-In-2050'
GROUP BY n.co_receipt_number,n.co_total_inward_quantity,n.co_balance_bags

Why I am not able to get Sum result?

Please, help me where am I doing worng?

im not getting sum value insted of that im getting that all records — Md Gosoddin, Jul 01 '20 at 06:42
You are returning X, you must get Balnce_Bags if you want get Sum result. — NEBEZ, Jul 01 '20 at 06:49
I think @jdweng got a valid point there, why exactly is your group by different? — Mong Zhu, Jul 01 '20 at 06:58
Perhaps my [SQL to LINQ Recipe](https://stackoverflow.com/questions/49245160/sql-to-linq-with-multiple-join-count-and-left-join/49245786#49245786) might help you. — NetMage, Jul 01 '20 at 23:42

not able to getting Sum Result when Group by using LINQ

0 Answers0