Your point is valid, it make sense just speak SQL to DB in some scenarios . A good ORM will enable people to do that easily as well.
However, good orms like LINQ in C# really shines in a lot of places.
However, good orms like LINQ in C# really shines in a lot of places.
> A good ORM will enable people to do that easily as well
I agree. EF isn't a terrible ORM and covers many use cases developers encounter when interacting with a database server in your average line of business app. But you do need to keep an eye on the SQL it generates with more complex queries i.e. beware of cartesian hand grenades. Fortunately MS provides some guidance on this kind of thing, but sadly many developers often don't bother to read the docs, and this is why ORM's get a bad name:
https://docs.microsoft.com/en-us/ef/core/performance/efficie...