将 coure sql 语句呈现为 linq 等效项

本文关键字：linq coure sql 语句 | 更新日期: 2023-09-27 17:56:29

谁能帮我转换我的sql语句yo linq查询SQL查询：

select
       MIN(a.StockCode) AS StockCode,
       MIN(a.Qty) AS Qty,
       MIN(a.TotalAmt) AS TotalAmt,
       MIN(a.DateAlloted)AS DateAlloted,
       MIN(a.Buy_Sold_Ind) AS Buy_Sold_Ind,
       convert(bit, min(convert(int, a.Posted))) AS Posted,
       convert(bit, min(convert(int, a.Reversed))) AS Reversed,   
       MIN(a.CustAID) AS CustAID 
from Stkb_Sold a
group by a.StockCode
order by count(a.StockCode) DESC

应该是这样的。

var result = from s in db.Stkb_Sold
             group s by s.StockCode into grp
             orderby grp.Count() descending
             select new
             {
                 StockCode = grp.Key,
                 Qty = grp.Min(x => x.Qty),
                 TotalAmt= grp.Min(x => x.TotalAmt),,
                 DateAlloted= grp.Min(x => x.DateAlloted),,
                 Buy_Sold_Ind= grp.Min(x => x.Buy_Sold_Ind),
                 Posted = grp.Min(x => x.Posted),
                 Reversed = grp.Min(x => x.Reversed),
                 CustAID = grp.Min(a.CustAID)
             };