"FOR UPDATE" hint not applied when using WithHint in .NET 9 with Npgsql

[houstonidze]

I tried Z.EntityFramework.Plus.EFCore with and Npgsql.EntityFrameworkCore.PostgreSQL
like this:
var items = await dbContext.Set<Items>().WithHint("FOR UPDATE").ToListAsync()

but query log shows that query is "SELECT * from items" without FOR UPDATE

ENV
Z.EntityFramework.Plus.EFCore version: 9.103.6.4
.NET version: 9
Database provider: Npgsql.EntityFrameworkCore.PostgreSQL v9
Database: PostgreSQL

Does Z.EntityFramework.Plus.EFCore hint support postgres?

[xkissboss]

您发给我的信件已经收到。 我会尽快处理，谢谢！ 肖振清

[JonathanMagnan]

Hello @houstonidze ,

Unfortunately this feature is only available for SQL Server at this moment. So, indeed, it doesn't work for PostgreSQL.

Best Regards,

Jon