小弟刚学linq一条简单的sql语句如何转为linq

[xyz7885696]

SELECT c.SiteName,max(d.ScheduleTime),a.EnterpriseName,a.EnterpriseInfoID FROM EnterpriseInfo AS a 
INNER JOIN EnterpriseSite AS b ON b.EnterpriseInfoID = a.EnterpriseInfoID
INNER JOIN SiteInfo AS c ON c.SiteInfoID = b.SiteInfoID 
INNER JOIN ScheduleInfo AS d ON d.EnterpriseSiteID = b.EnterpriseSiteID 
INNER JOIN EventType AS e ON e.EventTypeID = d.EventTypeID	
GROUP BY c.SiteName,a.EnterpriseName,a.EnterpriseInfoID

[q107770540]

//代码手打，提供思路参考
var query=from a in EnterpriseInfo 
          join b in EnterpriseSite on  a.EnterpriseInfoID equals b.EnterpriseInfoID 
          join c in SiteInfo  on  b.SiteInfoID  equals c.SiteInfoID 
          join d in ScheduleInfo on b.EnterpriseSiteID  equals d.EnterpriseSiteID 
          join e in EventType on d.EventTypeID equals e.EventTypeID
          group new{a,b,c,d} by new {c.SiteName,a.EnterpriseName,a.EnterpriseInfoID} into g
          select new{g.Key.SiteName,ScheduleTime=g.Max(d=>ScheduleTime),g.Key.EnterpriseName,g.Key.EnterpriseInfoID};

[你的选择H]

好多inner啊
建议考虑其他办法，连接太多

[Hatake]

[Quote=引用 1 楼 的回复:]

C# code

//代码手打，提供思路参考
var query=from a in EnterpriseInfo
join b in EnterpriseSite on a.EnterpriseInfoID equals b.EnterpriseInfoID
join c in SiteInfo on b.SiteInfoID equals……
[/Quote]

+ 1

楼主想要的是什么?只是转LINQ,还是要优化?

[xyz7885696]

[Quote=引用楼主 的回复:]
SQL code

SELECT c.SiteName,max(d.ScheduleTime),a.EnterpriseName,a.EnterpriseInfoID FROM EnterpriseInfo AS a
INNER JOIN EnterpriseSite AS b ON b.EnterpriseInfoID = a.EnterpriseInfoID
INNER JOIN Site……
[/Quote]
感谢 我已经自己写出来了