News for hackers. Stuff that matters.

A comment on What ORMs have taught me: just learn SQL (2014). Parent comment

Re:What ORMs have taught me: just learn SQL (2014) by scarface74 on Monday December 18, 2017 @06:52AM (#15951023)
If your ORM is downloading all of your data and querying client side, then your ORM "is doing it wrong".

Entity Framework and any other Linq to data provider translates the Linq expression to the native language of the source data and does it server side.

[ Parent | on HN ]
Re:What ORMs have taught me: just learn SQL (2014) by pjmlp on Monday December 18, 2017 @07:15AM (#15951111)
I know EF, which is why my comment also mentions "code that is even more convoluted that the SQL one and thus with less performance".

LINQ only allows for a fraction of what is possible with SQL, and good luck having the best queries generated out of it, if the RDMS doesn't happen to be SQL Server.

[ Parent | on HN ]
Re:What ORMs have taught me: just learn SQL (2014) by scarface74 on Monday December 18, 2017 @07:49AM (#15951253)
Actually my DMS is sometimes Mongo and the Mongo driver does pretty well at translating Linq to Mongo Query using the aggregation framework.

It all depends on the talent of the authors of the drivers.

[ Parent | on HN ]