Convert SQL to LINQ

[divesh12]

select SUM(total)
from MyTax mt1
inner join (
select Code,ID,TaxYear,Data,max(date) as FinalDate
from MyTax
group by Code,ID,TaxYear,Data) mt2
on mt1.Code = mt2.Code and mt1.ID = mt2.ID
and mt1.Data = mt2.Data and mt1.TaxYear = mt2.TaxYear
and mt1.date = mt2.date

[Sander Rossel]

What is it exactly that you want? What have you tried? Where are you stuck? We can't help you if you don't ask a question...

It's an OO world.

public class Naerling : Lazy<Person>{
public void DoWork(){ throw new NotImplementedException(); }
}

[thatraja]

Sorry, we don't spoon-feed. Take a look at this article & try yourself. Learn SQL to LINQ (Visual Representation)[^]

thatraja

FREE Code Conversion VB6 ASP VB.NET C# ASP.NET C++ JAVA PHP DELPHI ColdFusion
HTML Marquee & its alternatives

Nobody remains a virgin, Life screws everyone :sigh:

[Emmanuel Medina]

As Naerling and thatraja pointed out, there is no question, and we don't spood-feed, read the article thatraja linked, or if you are lazy brain-wise, buy Linqer (or any other SQL to LINQ conversion tool).