LINQ VB how to select records with the max date (highest date)

Question

I know how to do this in C#, but my dev team doesn't use C#...

here is the answer in C#: http://stackoverflow.com/questions/470440/linq-how-to-select-only-the-records-with-the-highest-date

How do I do this in VB?

Essentially, if I knew how to write lambda expressions in VB, I would be set, but the materials I have found are not helpful.

I also need to know why the Into identifier (i.e. "g") is always trying to be a function every time I move off the line, resulting in this error:

http://img19.imageshack.us/i/errno.png/

Answer 1

Dim q = From n In table _
        Group n By n.AccountId Into g _
        Select g.OrderByDescending(Function(t) t.Date).First()

Answer 2

Here's an example from MSDN of grouping in VB:

Dim query = From p In db.Products _
            Group p By p.CategoryID Into g = Group _
            Select CategoryID, MaxPrice = g.Max(Function(p) p.UnitPrice)

If you omit the "= Group", it will consider g as a function. Hope this helps.