Take a look at these issues: https://github.com/aspnet/EntityFrameworkCore/issues

How many of these are a result of of features that have nothing to do with getting data in and out of the database.

Get bare metal. Anything caked on adds friction.

That doesn't mean "write raw SQL". That means I want just enough of an ORM to give me type-safety for my queries and updates. Leave the rest at the door.