performance - 如何将 SQL 查询中的 Row_number() 转换为 LINQ to Entities 查询

Question

我想将此 SQL 查询转换为LINQ to Entities查询。如果有人有解决方案，请与我分享。

SELECT
    ROW_NUMBER() OVER (PARTITION BY Country, Year ORDER BY InvoiceId ASC) AS RowNo,
    Country,
    Year,
    InvoiceId
FROM
    Invoice

我的 SQL Server 表Invoice如下所示：

InvoiceId | FinancialYear | Country  | InvoiceNo
----------+---------------+----------+-----------
1         |  2017         | India    |  1
2         |  2017         | India    |  2
3         |  2018         | Indian   |  1
4         |  2017         | USA      |  1
5         |  2018         | USA      |  2

标签： performanceentity-frameworklinqlinq-to-entities