I'm using EF Core with SQL Server and PostgreSQL for two different production projects; it works like a charm, and the performance is great.

All recent projects in my company are PostgreSQL based (> 2000 production applications), and we have far fewer troubles with PostgreSQL than with Oracle, not to mention the licensing.

I have used it in multiple projects and it works great. The Npgsql.EntityFrameworkCore.PostgreSQL provider is always quickly updated when new versions of EF Core are shipped, and its primary maintainer @roji is also extremely talented and responsive. All around has been a pleasure to work with!

Coming from the MS ecosystem i can definitely vouch for EF core, but I am more of a Dapper person myself.

But I don't use PG because my needs are not so heavy nor have I the data sizes or advanced features that makes PG a more reliable choice over sqllite.

Npgsql has been good for me, although each major release there are a few teething issues.

I am using it in a hobby code first project. Had no issues with it, but my data model is admittedly not complex and the the data is small in size.

Well supported in EF core, great experience. Having said that, I’ve not used EF core with any other DB so have nothing to compare to.

I'm managing two medium sized projects on that stack, using both EF core and Dapper. I'm about to switch a third over from Oracle because I'm so tired of all the issues with Oracle.