I need to convert the following SQL script to Linq so that I may use it with EF Core:...SELECT
[Orders] AS A
(SELECT TOP 1 WITH TIES *
ORDER BY ROW_NUMBER() OVER (PARTITION BY OrderId ORDER BY PostDate DESC)
) AS B ON (b.OrderId = A.OrderId)
...What I converted this to is as follows:..