On: Why LINQ beats SQL

[ZenoArrow]

>"And I have yet to see one without an escape hatch allowing raw SQL."

I don't know where you've been looking, but from what I've seen it's an easy to find feature. To give two examples:

https://docs.djangoproject.com/en/1.10/topics/db/sql/

https://github.com/StackExchange/Dapper

[__jal → ZenoArrow]

Unless my reading ability is broken, we seem to be agreeing. I said I have never seen one that doesn't have one.

My point being that ORMs can't fully replace SQL, and the proof is they all provide an escape hatch.

[Daishiman → __jal]

They provide an escape hatch because the language has support for features such as temporary tables, native DB functions and transaction control that are nonstandard and have a hundred gotchas, and are therefore not amenable to implement in an ORM.

I have 30k lines of business logic written for Django that does not use that hatch even once.

[__jal → Daishiman]

Again, I see point of disagreement, other than an odd bit of defensiveness about ORMs.