3 ms·
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 LI
by nobody0 5y ago
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.
- teh_klev 5y agoWee nitpick, LINQ isn't an ORM, it's a querying API. Maybe you meant the original LINQ to SQL ORM which was deprecated in favour of Entity Framework (EF). > 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/efficient-querying https://docs.microsoft.com/en-us/ef/core/performance/efficie...