Convert SQL to LINQ to SQL

Question

I'm having big problems converting the next SQL to LINQ to SQL, any of which can be helped?

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

Or is it even better that anyone knows about an automatic SQl to LINQ converter?

Answer 1

See this existing stream.

If you decide to do it manually, Linqpad should be helpful.

Answer 2

I tried linqpad, but not for converting SQL to linq, but its actual use is to replace sql with linq to query your database

, linqer , SQL- LINQ. .

http://www.sqltolinq.com/

Answer 3

linqpad does not convert.

free converter

http://windowsphone.interoperabilitybridges.com/articles/sql-to-linq-converter

Note. Start with SQLite on Windows, not WindowsPhone.

Answer 4

To go from LINQ -> SQL, try the following:

        var db = new DBModelDataContext();
        StringBuilder sb = new StringBuilder();
        StringWriter sw = new StringWriter(sb);
        db.Log = sw; //set the writer

        var items = (from rec in db.Table1
                     select rec).ToList();

        var sql = sb.ToString(); //here is the SQL from LINQ.