将SQL查询转换为LINQ - 无法正常工作

作者: 子阳
发布时间: 2025-01-19 05:35:28 (1月前)
转自：

3 条回复

0#
回复此人
遇见你 | 2019-08-31 10-32

<div class =“post-text”itemprop =“text”> <P> 尝试以下更简单的方法： </p> <pre> <code> var res = (from nums in _db.PhoneNumbers.Where(x => NumberRangeId == id) join serviceItems in _db.PhoneNumberServiceItems on nums.PhoneNumber_Id equals serviceItems.Id select new {serviceItems = serviceItems, nums = nums}) .OrderByDescending(x => x.serviceItems.Created) .GroupBy(x => x.nums.PhoneNumber_Id) .Select(x => x.First()) .Select(x => new {Id = x.nums.PhoneNumber_Id, state = x.serviceItems.State, maxDate = x.serviceItems.Created}) .ToList(); </code> </pre> </DIV>

编辑
1#
回复此人
SHOU宅大可爱 | 2019-08-31 10-32

<div class =“post-text”itemprop =“text”> <pre> <code> var recentPhoneNos= from psi in _db.PhoneNumberServiceItems group psi by psi .PhoneNumber_Id into psiTemp select new { PhoneNumber_Id = psiTemp.Key, MaxDate = psiTemp.Max(i=> i.Created) }; var res=from serviceItems in _db.PhoneNumberServiceItems join nums in _db.PhoneNumbers on serviceItems.PhoneNumber_Id equals nums.Id join serviceGroup in recentPhoneNos on nums.Id equals serviceGroup .PhoneNumber_Id where nums.NumberRangeId == id && serviceGroup.MaxDate select new { State = serviceItems.State, NumId = serviceGroup.NumId, Created = serviceGroup.MaxDate } ; </code> </pre> </DIV>

编辑

登录后才能参与评论