The most basic and frequently used Linq operators are very commonly defined in widely used JS libraries. They just have different names (in fact, they have more traditional names than in Linq). Select becomes map, Where becomes filter, First and FirstOrDefault become [0].
Almost no library I know of (including I think the ones you linked to) bother to make the implementation lazy as in .NET Linq, they just evaluate immediately using arrays.
Binding for Reactive Extensions for JavaScript(RxJS) and IntelliSense Generator
NuGet install support
Updated recently (last release Jan 2011)
Syntax conforms to lambda syntax in C#
Cons
The linq.js library is a little large.
If you are already using jQuery or other js library, the most commonly used functionality is probably already available. See especially jQuery's filter, and 'Any' methods.
I recommend taking a look at underscore.js. It is not a direct LINQ port like some of the others, but is a very comfortable "LINQ-like" experience. It supports all the filter, sort and project options that I need and has excellent documentation and community support.
As a bonus for Knockout users, there is UnderscoreKO that adds Underscore's array methods to Knockout's observable arrays. Demo
There are some duplicating libraries out there that try to port LINQ to JavaScript with a similar syntax and method names. However, in the JS community, the library that is getting really popular and providing the same functionality is Underscore.js.
This looks really great! Maybe I just don't understand the point of Rx and observables compared to setting event handlers through something like jQuery.
I've tried out most of these -- and I really like $linq: http://jscriptlinq.codeplex.com/ the best. It simply works the way you would expect c# linq to work -- including the chain ability.
I personally find the LINQ/set operations Union, Intersect, Except and Distinct on enumerables in .NET. very useful. There is a jquery plugin called jQuery Array Utilities which provides these methods to be used on arrays.