Window functions in EF Core

[shoooe]

Is there any way I can use window functions (like rank and similar) within EF Core with Npgsql?
If now, could we provide a translation for the common problem known as "greatest-n-per-group".

That's solved efficiently with window functions.

Thanks

[shoooe]

Apparently there's some kind of support in EF Core for at least row number.

[roji]

@shoooe EF Core already generates window functions for some LINQ queries, e.g. see dotnet/efcore#17936, and for others it generates CROSS APPLY (or lateral joins for PostgreSQL). dotnet/efcore#12747 already tracks this on the EF Core side, so am going to close this as a duplicate of that.