Coming from Javaland to C#, Entity Framework is a breath of fresh air.

The Npgsql driver automatically applies PG-specific tricks without me having to do anything special

The only path I had to do myself is the data ingress point that had some race condition issues, everything else seems to perform pretty well out of the box.