When will we have LINQ in Java?
java.dzone.com
java.dzone.com
For Microsoft, who makes a lot of money selling a relational database server, marrying their flagship language with SQL makes sense, but I doubt it benefits anyone else.
Not even the developers who use it.
I can easily imagine all the programs that now rely on a relational database (or something hammered into a relational model) when any number of other data storage strategies would be a better fit. When all you know is a hammer, everything looks like a nail.
And that's the problem - you have a very Java-like syntax for the rest of C# with intrusions of SQL-like syntax. I'm not sure it's a good idea.
A solution more like the comprehensions you find in functional languages would probably be neater and more flexible.