LINQ to JavaScript

New Post: JSLINQ and LIKE Operation?

shoaibshaikh — Wed, 25 Jun 2008 12:53:16 GMT

Did JSLINQ support 'Like' operation? if yes can anyone give any idea how to use it?

CREATED ISSUE: few more missing 'var' keywords

666shooter — Sun, 02 Mar 2008 16:13:08 GMT

same as the item about the Distinct for loop goes for line 206, 227

CREATED ISSUE: missing 'var' in for loop

666shooter — Sun, 02 Mar 2008 16:10:30 GMT

minor issue:
in the Distinct function on line 177 the i variable is missing the 'var' keyword.

for (i = 0; i < this.length; i++)

should be:

for (var i = 0; i < this.length; i++)

UPDATED RELEASE: v1.03 (Feb 10, 2008)

Sun, 10 Feb 2008 21:47:53 GMT

* Added Intersect Operator
* Added DefaultIfEmpty Operator
* Added ElementAtOrDefault Operator
* Added FirstOrDefault Operator
* Added LastOrDefault Operator
* Started adding Usage Examples
** Count Word Occurrences
** Count Set of Words

UPDATED WIKI: Home

crpietschmann — Sat, 02 Feb 2008 01:44:21 GMT

Project Description
LINQ to JavaScript (JSLINQ) is an implementation of LINQ to Objects implemented in JavaScript. It is built using a set of extension methods built on top of the JavaScript Array object. If you are using an Array, you can use LINQ to JavaScript.

View Interactive SDK: http://simplovation.com/jslinqsdk/

This project is maintained by Chris Pietschmann (http://pietschsoft.com), and sponsored by Simplovation http://simplovation.com.

What is LINQ to JavaScript?

LINQ to JavaScript (JSLINQ for short) is an implementation of LINQ to Objects implemented in JavaScript. It is built using a set of extension methods built on top of the JavaScript Array object. If you are using an Array, you can use JSLINQ.

If you don't know what LINQ is; it's a new featureset in the .NET Framework 3.5 that allows more SQL-like querying of any kind of data. In the case of LINQ to JavaScript, it provides the ability to query against Arrays.

Example Usage

var myList = [
            {FirstName:"Chris",LastName:"Pearson"},
            {FirstName:"Kate",LastName:"Johnson"},
            {FirstName:"Josh",LastName:"Sutherland"},
            {FirstName:"John",LastName:"Ronald"},
            {FirstName:"Steve",LastName:"Pinkerton"}
            ];
            
var exampleArray = From(myList).
                   Where("item.FirstName == 'Chris'").
                   OrderBy("item.FirstName").
                   Select("item.FirstName");

Using LINQ to JavaScript

We will use this Array for the following examples:

var myList = [
            {FirstName:"Chris",LastName:"Pearson"},
            {FirstName:"Kate",LastName:"Johnson"},
            {FirstName:"Josh",LastName:"Sutherland"},
            {FirstName:"John",LastName:"Ronald"},
            {FirstName:"Steve",LastName:"Pinkerton"}
            ];

Use the From operator just as you would in LINQ in .NET
The From operator is optional, and only included in LINQ to JavaScript to be able to support the same syntax as LINQ.

var example = From(myList);

Using the Where operator to specify query criteria
In this case, we're getting all items in the Array that have FirstName property set to Chris.

// Send in the clause as a string to be evaluted
var whereExample1 = From(myList).
                      Where("item.FirstName == 'Chris'");
 
// Send in the clause as a method to be evaluated
var whereExample2 = From(myList).
                      Where(function(item){return item.FirstName == 'Chris';});

Using the Select operator to specify which data to return
In this case, we're going to return only the FirstName property of each item in the Array.

// Send in the clause as a string to be evaluted
var selectTest1 = From(myList).
                Select("item.FirstName");
 
// Send in the clause as a method to be evaluted
var selectTest2 = From(myList).
                Select(function(item){return item.FirstName;});

Using the OrderBy operator to determine how to sort the order of the items in the Array
In this case, we're going to order them by the FirstName property.

// Send in the clause as a string to be evaluted
var sortTest1 = From(myList).
             OrderBy("item.FirstName");
 
// Send in the clause as a method to be evaluted
var sortTest1 = From(myList).
             OrderBy(function(item){return item.FirstName});

UPDATED RELEASE: 1.02 (Feb 01, 2008)

Sat, 02 Feb 2008 01:35:10 GMT

* A few Bug fixes that were revealed with Unit Tests
* Interactive SDK Created
* Unit Test Created
** Intial testing of the Samples Unit Tests yielded the following speed results for all tests:
*** IE7: ~10 milliseconds
*** FireFox 2: ~10 milliseconds
*** Safari 3 for Windows: ~4 milliseconds

UPDATED RELEASE: 1.02

Sat, 02 Feb 2008 01:34:31 GMT

UPDATED RELEASE: 1.02

Sat, 02 Feb 2008 01:31:43 GMT

CREATED RELEASE: 1.02

Sat, 02 Feb 2008 01:31:12 GMT

* A few Bug fixes that were revealed with Unit Tests
* Interactive SDK Created
* Unit Test Created
** Intial testing of the Samples Unit Tests yielded the following speed results:
*** IE7: ~10 milliseconds
*** FireFox 2: ~10 milliseconds
*** Safari 3 for Windows: ~4 milliseconds

UPDATED WIKI: Home

crpietschmann — Wed, 30 Jan 2008 18:53:03 GMT

Project Description
LINQ to JavaScript (JSLINQ) is an implementation of LINQ to Objects implemented in JavaScript. It is built using a set of extension methods built on top of the JavaScript Array object. If you are using an Array, you can use LINQ to JavaScript.

This is created and maintained by Chris Pietschmann (http://pietschsoft.com).

What is LINQ to JavaScript?

var myList = [
            {FirstName:"Chris",LastName:"Pearson"},
            {FirstName:"Kate",LastName:"Johnson"},
            {FirstName:"Josh",LastName:"Sutherland"},
            {FirstName:"John",LastName:"Ronald"},
            {FirstName:"Steve",LastName:"Pinkerton"}
            ];
            
var exampleArray = From(myList).
                   Where("item.FirstName == 'Chris'").
                   OrderBy("item.FirstName").
                   Select("item.FirstName");

Using LINQ to JavaScript

We will use this Array for the following examples:

var myList = [
            {FirstName:"Chris",LastName:"Pearson"},
            {FirstName:"Kate",LastName:"Johnson"},
            {FirstName:"Josh",LastName:"Sutherland"},
            {FirstName:"John",LastName:"Ronald"},
            {FirstName:"Steve",LastName:"Pinkerton"}
            ];

Use the From operator just as you would in LINQ in .NET
The From operator is optional, and only included in LINQ to JavaScript to be able to support the same syntax as LINQ.

var example = From(myList);

Using the Where operator to specify query criteria
In this case, we're getting all items in the Array that have FirstName property set to Chris.

// Send in the clause as a string to be evaluted
var whereExample1 = From(myList).
                      Where("item.FirstName == 'Chris'");
 
// Send in the clause as a method to be evaluated
var whereExample2 = From(myList).
                      Where(function(item){return item.FirstName == 'Chris';});

Using the Select operator to specify which data to return
In this case, we're going to return only the FirstName property of each item in the Array.

// Send in the clause as a string to be evaluted
var selectTest1 = From(myList).
                Select("item.FirstName");
 
// Send in the clause as a method to be evaluted
var selectTest2 = From(myList).
                Select(function(item){return item.FirstName;});

Using the OrderBy operator to determine how to sort the order of the items in the Array
In this case, we're going to order them by the FirstName property.

// Send in the clause as a string to be evaluted
var sortTest1 = From(myList).
             OrderBy("item.FirstName");
 
// Send in the clause as a method to be evaluted
var sortTest1 = From(myList).
             OrderBy(function(item){return item.FirstName});

UPDATED RELEASE: 1.01 (Jan 30, 2008)

Wed, 30 Jan 2008 18:51:50 GMT

This release adds the following functionality:
- Added the OrderByDescending Operator
- Added the SelectMany Operator
- Added the Count Operator
- Added the Distinct Operator
- Added the Any Operator
- Added the All Operator
- Made it so you can access the elements "index" within the clause/predicate of each of the following Operators: Where, Count, Any, All
- Added the Reverse Operator, this also allows access to the elements "index" within the clause/predicate
- Added First Operator, this also allows access to the elements "index" within the clause/predicate
- Added Last Operator, this also allows access to the elements "index" within the clause/predicate
- Added ElementAt Operator
- Added Concat Operator - this is identical to JavaScripts Array.concat method

CREATED RELEASE: 1.01

Wed, 30 Jan 2008 18:48:42 GMT

UPDATED WIKI: Home

crpietschmann — Wed, 30 Jan 2008 18:46:39 GMT

Project Description
LINQ to JavaScript (JSLINQ) is an implementation of LINQ to Objects implemented in JavaScript. It is built using a set of extension methods built on top of the JavaScript Array object. If you are using an Array, you can use LINQ to JavaScript.

This is created and maintained by Chris Pietschmann (http://pietschsoft.com).

What is LINQ to JavaScript?

var myList = [
            {FirstName:"Chris",LastName:"Pearson"},
            {FirstName:"Kate",LastName:"Johnson"},
            {FirstName:"Josh",LastName:"Sutherland"},
            {FirstName:"John",LastName:"Ronald"},
            {FirstName:"Steve",LastName:"Pinkerton"}
            ];
            
var exampeArray = From(myList).
                   Where("item.FirstName == 'Chris'").
                   OrderBy("item.FirstName").
                   Select("item.FirstName");

Using LINQ to JavaScript

We will use this Array for the following examples:

var myList = [
            {FirstName:"Chris",LastName:"Pearson"},
            {FirstName:"Kate",LastName:"Johnson"},
            {FirstName:"Josh",LastName:"Sutherland"},
            {FirstName:"John",LastName:"Ronald"},
            {FirstName:"Steve",LastName:"Pinkerton"}
            ];

Use the From operator just as you would in LINQ in .NET
The From operator is optional, and only included in LINQ to JavaScript to be able to support the same syntax as LINQ.

var example = From(myList);

Using the Where operator to specify query criteria
In this case, we're getting all items in the Array that have FirstName property set to Chris.

// Send in the clause as a string to be evaluted
var whereExample1 = From(myList).
                      Where("item.FirstName == 'Chris'");
 
// Send in the clause as a method to be evaluated
var whereExample2 = From(myList).
                      Where(function(item){return item.FirstName == 'Chris';});

Using the Select operator to specify which data to return
In this case, we're going to return only the FirstName property of each item in the Array.

// Send in the clause as a string to be evaluted
var selectTest1 = From(myList).
                Select("item.FirstName");
 
// Send in the clause as a method to be evaluted
var selectTest2 = From(myList).
                Select(function(item){return item.FirstName;});

Using the OrderBy operator to determine how to sort the order of the items in the Array
In this case, we're going to order them by the FirstName property.

// Send in the clause as a string to be evaluted
var sortTest1 = From(myList).
             OrderBy("item.FirstName");
 
// Send in the clause as a method to be evaluted
var sortTest1 = From(myList).
             OrderBy(function(item){return item.FirstName});

UPDATED WIKI: Home

crpietschmann — Wed, 30 Jan 2008 18:46:25 GMT

Project Description
LINQ to JavaScript (JSLINQ) is an implementation of LINQ to Objects implemented in JavaScript. It is built using a set of extension methods built on top of the JavaScript Array object. If you are using an Array, you can use LINQ to JavaScript.

This is created and maintained by Chris Pietschmann (http://pietschsoft.com Chris Pietschmann).

What is LINQ to JavaScript?

var myList = [
            {FirstName:"Chris",LastName:"Pearson"},
            {FirstName:"Kate",LastName:"Johnson"},
            {FirstName:"Josh",LastName:"Sutherland"},
            {FirstName:"John",LastName:"Ronald"},
            {FirstName:"Steve",LastName:"Pinkerton"}
            ];
            
var exampeArray = From(myList).
                   Where("item.FirstName == 'Chris'").
                   OrderBy("item.FirstName").
                   Select("item.FirstName");

Using LINQ to JavaScript

We will use this Array for the following examples:

var myList = [
            {FirstName:"Chris",LastName:"Pearson"},
            {FirstName:"Kate",LastName:"Johnson"},
            {FirstName:"Josh",LastName:"Sutherland"},
            {FirstName:"John",LastName:"Ronald"},
            {FirstName:"Steve",LastName:"Pinkerton"}
            ];

Use the From operator just as you would in LINQ in .NET
The From operator is optional, and only included in LINQ to JavaScript to be able to support the same syntax as LINQ.

var example = From(myList);

Using the Where operator to specify query criteria
In this case, we're getting all items in the Array that have FirstName property set to Chris.

// Send in the clause as a string to be evaluted
var whereExample1 = From(myList).
                      Where("item.FirstName == 'Chris'");
 
// Send in the clause as a method to be evaluated
var whereExample2 = From(myList).
                      Where(function(item){return item.FirstName == 'Chris';});

Using the Select operator to specify which data to return
In this case, we're going to return only the FirstName property of each item in the Array.

// Send in the clause as a string to be evaluted
var selectTest1 = From(myList).
                Select("item.FirstName");
 
// Send in the clause as a method to be evaluted
var selectTest2 = From(myList).
                Select(function(item){return item.FirstName;});

Using the OrderBy operator to determine how to sort the order of the items in the Array
In this case, we're going to order them by the FirstName property.

// Send in the clause as a string to be evaluted
var sortTest1 = From(myList).
             OrderBy("item.FirstName");
 
// Send in the clause as a method to be evaluted
var sortTest1 = From(myList).
             OrderBy(function(item){return item.FirstName});

NEW POST: A Better Query Tool Than jQuery?

crpietschmann — Sat, 26 Jan 2008 04:24:04 GMT

If you have any ideas for functionality for JSLINQ, feel free to submit them to the Issue Tracker; along with any code demonstrating them. And, if they make sense for the scope of this project, I'll incorporate them into the project.

Currently, CodePlex is the only home page for this project, I'm thinking about creating a site dedicated to it. It is a great idea to create a section where others can post JSLINQ Extensions. I just created an Extensions tag in the Discussion forums, so just post any code for Extensions there for the time being. If it becomes popular enough with people posting their own JSLINQ extensions I'll create an Extensions section on the projects website, once I create it.

Thanks for the suggestions!

NEW POST: Script and LINQ

NikhilK — Fri, 25 Jan 2008 08:14:48 GMT

Nice - Just thought I'd post a link to a post I did a while back demonstrating LINQ concepts in script - http://www.nikhilk.net/ScriptAndLINQ.aspx.
Also, script# supports these APIs as well, as mentioned in the post.

NEW POST: A Better Query Tool Than jQuery?

stimpy77 — Thu, 24 Jan 2008 22:27:04 GMT

JSLINQ is a really interesting idea, by the way.

NEW POST: A Better Query Tool Than jQuery?

stimpy77 — Thu, 24 Jan 2008 22:23:17 GMT

I take it this can run in the browser (Firefox, Opera, etc).

Is it inherently extensible like jQuery is? jQuery's extensibility seems to be more of a service than a feature since Javascript objects are all extensible; is there a home page for JSLINQ where jQuery-like extensions can be featured?

For that matter, what about appending jQuery object with JSLINQ's object definition so that jQuery extensions "just work" with JSLINQ? :D

UPDATED RELEASE: 1.00 (Jan 24, 2008)

Thu, 24 Jan 2008 18:44:03 GMT

This is the first release of LINQ to JavaScript (JSLINQ) and includes the following operators:
* From
* Where
* OrderBy
* Select

UPDATED RELEASE: 1.00 (Jan 24, 2008)

Thu, 24 Jan 2008 18:43:00 GMT

This is the first release of LINQ to JavaScript (JSLINQ) and includes the following operators:
* From
* Where
* OrderBy
* Select