将 SQL 转换为 LINQ to SQL

我在将以下 SQL 转换为 LINQ to SQL 时遇到了很大的麻烦，有人能帮忙吗？

SELECT     dbo.ExpensesGroup.ExpenseGroupId, dbo.ExpensesGroup.Title, SUM(dbo.Expenses.Amount) AS TotalAmount, MAX(dbo.Expenses.DateLastTickled) 
                      AS LastTickledDate, MAX(dbo.ExpensesGroup.DateTime) AS Date, Username
FROM         dbo.Expenses INNER JOIN
                      dbo.ExpensesGroup ON dbo.Expenses.ExpenseId = dbo.ExpensesGroup.ExpensesId
WHERE     dbo.Expenses.Status = 'AwaitingApproval' or dbo.Expenses.Status = 'AwaitingApprovelGrouping'
GROUP BY dbo.ExpensesGroup.ExpenseGroupId, dbo.ExpensesGroup.Title, dbo.Expenses.Username
ORDER BY MAX(dbo.ExpensesGroup.DateTime) DESC, dbo.ExpensesGroup.Title

或者更好的是有人知道自动 SQl 到 LINQ 转换器吗？

See this https://stackoverflow.com/questions/296972/sql-to-linq-tool现有线程。

如果你决定用手做，Linqpad http://www.linqpad.net/应该有用。