LINQ怎么写，求高手指教！
本帖最后由 q107770540 于 2013-12-10 21:16:50 编辑

select d.Plate,b.TerminalSign,b.[Longitude],b.[Latitude],b.[speed],b.[direction],b.[FullOrEmpty],b.[AccStyle],b.[GpsTime],e.Name 
from [TaxiRadarHistory].[dbo].TaxiRdHistorydata_20131210 as b 
right join (select [TerminalSign],max(GpsTime) as GpsTime  from [TaxiRadarHistory].[dbo].TaxiRdHistorydata_20131210 where GpsTime>dateadd(mi,-600,getdate()) group by TerminalSign) as a 
on b.TerminalSign=a.TerminalSign and b.GpsTime=a.GpsTime 
left join TR_Device as c on a.TerminalSign=c.DeviceNum 
left join TR_Car d on c.DeviceID=d.Phone and d.IsScrapped=0 
left join TaxiRdDriverLogin e on b.TerminalSign=e.TerminalSN  
where e.LoginOut is null and e.LoginIn<b.GpsTime and b.TerminalSign='0867493010086303'

这一段SQL语句怎么用LINQ写？求高手帮忙！
[解决办法]
我想你参考这个帖子可以得到答案：

http://bbs.csdn.net/topics/390666251