将 SQL 转换为 LINQ 到 SQL [英] Convert SQL to LINQ to SQL

问题描述

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

I'm having great trouble in converting the following SQL to LINQ to SQL, any one able to help out?

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 转换器?

Or even better anyone know of an automatic SQl to LINQ converter?

推荐答案

参见 this 现有线程.

如果您决定手动完成，Linqpad 应该很有用.

If you decide to do it by hand, Linqpad should be useful.

这篇关于将 SQL 转换为 LINQ 到 SQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！