How to implement this SQL Script into LINQ Query?

yahoo_pangilinan

SELECT (SELECT columnA FROM (SELECT columnA as A, columnB as B, ROW_NUMBER() OVER (ORDER BY columnA DESC) as count FROM tableA WHERE columnA = 'Name') x WHERE x.count = 1) as Answer1