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

问题描述

在将以下SQL转换为LINQ转换为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?

推荐答案

请参阅此现有线程.

如果您决定手动操作，则 Linqpad 应该会有用.

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

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