@Kasimier: My first name is "Kázmér" which is the hungarian derivation of the polish name Casimir: http://en.wikipedia.org/wiki/Casimir. And in hungarian, Kázmér's nick name is Kazi.That explains the name only, not avatar similarities .
Html5/JS as a development tool for new generation Win8 applications is the worst news in my career, despite backward compatibility. The message sounds like my .net knowledge will be obsolete in near future. If I have to invest a lot more in Htm5/JS, why should I choose Windows?
Let me mention Charles Simonyi's father here /also named Charles Simonyi i.e. Karoly Simonyi in hungarian/ he was a prominent scientist and excellent teacher, and he wrote one of my favorite book: "A cultural history of Physics".
I think, the answer is how do they implement the IEnumerable<T> interface. It's possible to open the SQL query within the GetEnumerator() implementation, then it can build the correct and exact sql query which returns the requested result only from the server.
So, if you don't enumerate on a LINQ construct whatever is that, you don't contact with the sql server. A rude sample: