将 vb.net Linq 转换为 c# 分组依据，带有 sum & max & min

本文关键字：amp 带有 sum min max Linq net vb 转换 | 更新日期: 2023-09-27 18:34:39

我正在尝试将 Linq 查询 VB.NET 转换为 C#

我不确定如何在 C# 中的一行语句中选择 Sum、Max 和 Min，这是否可以在 c# 中完成，如果是这样，则如何完成。

VB.NET 林克查询

Dim rule4Summed = (From r In ArkleSelection1.ArkleMarket1.Rule4sList
                        Where r.Rule4ApplicationCode = "E" And r.DeductionEndTime >Bet.BetSlip.DateScanned
                        Group By r.ArkleMarket1.MarketIdentifier Into
                        sumR4 = Sum(r.DeductionPercentForRunner),
                        dedEndTime = Max(r.DeductionEndTime),
                        dedStartTime = Min(r.DeductionStartTime)).FirstOrDefault

将 vb.net Linq 转换为 c# 分组依据，带有 sum & max & min

这应该有效：-

var rule4Summed = (from r in ArkleSelection1.ArkleMarket1.Rule4sList
                  where r.Rule4ApplicationCode == "E" 
                        && r.DuductionEndTime > Bet.Betslip.DateScanned
                  group r by r.ArkleMarket1.MarketIdentifier into g
                  select new 
                  {
                     sumR4 = g.Sum(x => x.DeductionPercentForRunner),
                     dedEndTime = g.Max(x => x.DeductionEndTime),
                     dedStartTime = g.Min(x => x.DeductionStartTime)
                  }).FirstOrDefault();