SecretSoftware wrote:
But I mean SQL as a language should  not be used alot. I mean with LINQ you can do alot more, by writing few words. That is real value. Because now your program will spend less time in loops and just more time idle waiting for the next instructions from the user. It really is breath taking and will revolutionize the way source code looks. Most of it will not have loops except in few places. Which is great!



I agree and I look at it as another step down the path taken with ADO.NET's disconnected DataSet paradigm.

We go to the well, but not too often. Pruning shall be client-side.

Hardware & especially memory is allowing this route, imho, and I am also very excited about what you point out, ss.