On: Why LINQ beats SQL

[jordanlev]

It's not an ORM, more like an alternate way to write queries that's kind of embedded in the language itself (as opposed to SQL where you're putting together a string). If you're familiar with the Rails world, I'd say it's more like "Arel" than "ActiveRecord".

[jedberg → jordanlev]

But Linq literally generates SQL before sending it to the server:

https://msdn.microsoft.com/en-us/library/system.data.linq.da...

Doesn't that make it an ORM?

[contextfree → jedberg]

That link is about LINQ to SQL, not LINQ proper

* LINQ is a set of language features and libraries that help enable better ORMs, among other things

* LINQ to SQL and Entity Framework are examples of ORMs that use the LINQ features

[recursive → jedberg]

No, because you can use linq without even having a server or even a database. ORMs are one application of linq, but it's a more general concept.