Multiple Join and Max with Max Value in LINQ

Question

I have this SQL code who works:

select Remarks,a.NoMachine,Color,Status
from TestGoogleChart a inner join tblMachine b on a.NoMachine = b.Machine_Code
where a.Id = (select max(id) from TestGoogleChart c where c.NoMachine = a.NoMachine)
order by Remarks asc

These query can be executed in SQL Server.

I want to covert that query into LINQ. Please anybody help me out from this problem.

Thank you very much.

Regards. Satya