哪位大侠帮忙把t-sql语句转成linq呢，我写了好久还是写不对

[神都码农]

select b.OrderId, A_OrderInfo.UserName,A_OrderInfo.City,A_OrderInfo.OrderDate,b.buyNum from A_OrderInfo inner join
(select SUM(A_OrderPro.ProNum) buyNum,A_OrderInfo.OrderId from A_OrderInfo
inner join A_OrderPro on A_OrderPro.OrderId = A_OrderInfo.OrderId
where A_OrderPro.SpareVar ='VXZ1102002' group by A_OrderInfo.OrderId) as b
on A_OrderInfo.OrderId = b.OrderId where DATEDIFF(DAY,A_OrderInfo.OrderDate,GETDATE())<=3

[神都码农]

我也想做兔子党

[神都码农]

[Quote=引用 4 楼 q107770540 的回复:]
C# code


var query=from a in A_OrderInfo
join b in (from a0 in A_OrderInfo
join ap in A_OrderPro on ap.OrderId equals a0.OrderId
where ap.SpareVa……
[/Quote]
var endTime = DateTime.Now.AddDays(-3);
var query = from x in dataContext.A_OrderPro
where x.SpareVar== styleNo
group x by x.OrderId
into g
from i in dataContext.A_OrderInfo
where i.OrderId == g.Key && i.OrderDate >= endTime
orderby i.OrderDate descending
select new A_SaleRecord
{
BuyCount = g.Sum(e => e.ProNum).HasValue?g.Sum(e => e.ProNum).Value:0,
UserCity = i.City,
UserName = i.UserName,
CreateDate = i.OrderDate

}; 我写出来啦，大哥瞅瞅指点下俺

[神都码农]

有人来吗?别沉了呀，在线等答案！！！

[神都码农]

来人啊，大侠们，赶紧的给俺指点下

[q107770540]

var query=from a in A_OrderInfo
          join b in (from a0 in A_OrderInfo
                   join ap in A_OrderPro on ap.OrderId equals a0.OrderId
                   where ap.SpareVar =="VXZ1102002"
                   group a0 by a0.OrderId into g
                   select new 
                   { 
                         buyNum=g.Sum(t=>t.ProNum),
                         OrderId=g.Key
                   })
        on a.OrderId equals b.OrderId
        where System.Data.Linq.SqlClient.SqlMethods.DateDiffDay(a.OrderDate,DateTime.Now)<=3
        select new 
         { b.OrderId, a.UserName,a.City,a.OrderDate,b.buyNum};