Per-operation collation in Entity Framework Core

I have a database which uses the default C collation. This database is for an app that will be used by both English and French users, so I can't set a specific collation at design-time on the database itself, but I must do it on a per-operation basis, based on the locale of the current thread.

PostgreSQL has support for this:

SELECT * 
FROM my_table 
ORDER BY y COLLATE "fr_FR";

I know we can do it at design-time in EF Core code-first Migrations, but is there any way to do it on a per-operation basis?