LINQ to JavaScript

Reviewed: v2.10 (十月 03, 2009)

rebben — Sun, 04 Oct 2009 02:47:10 GMT

Rated 4 Stars (out of 5) - I want learn linq........................................

Created Feature: Make all methods access "C#-like Lambda Expressions" where applicable

crpietschmann — Thu, 18 Jun 2009 22:00:30 GMT

Make all methods access "C#-like Lambda Expressions" where applicable

The "OrderBy" and "OrderByDescending" methods already have this done.

For Example:
var sample = JSLINQ(Samples.People)
.OrderBy("item => item.FirstName");

Closed Issue: Modify "OrderBy" and "OrderByDescending" to access "C#-like Lambda" expressions also.

crpietschmann — Thu, 18 Jun 2009 21:59:07 GMT

Modify "OrderBy" and "OrderByDescending" to access "C#-like Lambda" expressions also.
var sample = JSLINQ(Samples.People)
.OrderBy("item => item.FirstName");
Comments:

Done

Source code checked in, #20760

crpietschmann — Thu, 18 Jun 2009 21:59:00 GMT

Item # 4210: Modify "OrderBy" and "OrderByDescending" to access "C#-like Lambda" expressions also. var sample = JSLINQ(Samples.People) .OrderBy("item => item.FirstName");

Created Issue: Modify "OrderBy" and "OrderByDescending" to access "C#-like Lambda" expressions also.

crpietschmann — Thu, 18 Jun 2009 21:58:32 GMT

Modify "OrderBy" and "OrderByDescending" to access "C#-like Lambda" expressions also.
var sample = JSLINQ(Samples.People)
.OrderBy("item => item.FirstName");

Closed Issue: Modify "OrderByDescending" to accept the field/property to order by as a string in addition to accepting a "clause function"/lambda expression.

crpietschmann — Thu, 18 Jun 2009 21:24:19 GMT

Modify "OrderByDescending" to accept the field/property to order by as a string in addition to accepting a "clause function"/lambda expression.

var sample = JSLINQ(Samples.People)
.OrderByDescending("FirstName");
Comments:

Done

Source code checked in, #20742

crpietschmann — Thu, 18 Jun 2009 21:24:11 GMT

Item # 4207: Modify "OrderByDescending" to accept the field/property to order by as a string in addition to accepting a "clause function"/lambda expression.

Created Issue: Modify "OrderByDescending" to accept the field/property to order by as a string in addition to accepting a "clause function"/lambda expression.

crpietschmann — Thu, 18 Jun 2009 21:23:54 GMT

Updated Wiki: Home

crpietschmann — Thu, 18 Jun 2009 21:13:12 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 project is maintained by Chris Pietschmann.

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 = JSLINQ(myList)
                   .Where(function(item){ return item.FirstName == "Chris"; })
                   .OrderBy(function(item) { return item.FirstName; })
                   .Select(function(item){ return 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"}
            ];

Create an Instance of the JSLINQ object with your data
You need to create a new JSLINQ object and pass it the javascript array of data that you will be querying.

var example = JSLINQ(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.

var whereExample1 = JSLINQ(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.

var selectTest2 = JSLINQ(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.

var sortTest1 = JSLINQ(myList)
             .OrderBy(function(item){ return item.FirstName; });

Closed Issue: Modify "Select" to accept a single field/property to select by passing it in as a string.

crpietschmann — Thu, 18 Jun 2009 21:10:04 GMT

Modify "Select" to accept a single field/property to select by passing it in as a string.

Example:
var sample = JSLINQ(Samples.People)
.Select("FirstName");
Comments:

Done

Source code checked in, #20739

crpietschmann — Thu, 18 Jun 2009 21:09:24 GMT

Item # 4206: Modify "Select" to accept a single field/property to select by passing it in as a string.

Created Issue: Modify "Select" to accept a single field/property to select by passing it in as a string.

crpietschmann — Thu, 18 Jun 2009 21:06:09 GMT

Modify "Select" to accept a single field/property to select by passing it in as a string.

Example:
var sample = JSLINQ(Samples.People)
.Select("FirstName");

Updated Wiki: Home

crpietschmann — Thu, 18 Jun 2009 21:04:11 GMT

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 = JSLINQ(myList)
                   .Where(function(item){ return item.FirstName == "Chris"; })
                   .OrderBy("FirstName")
                   .Select(function(item){ return 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"}
            ];

Create an Instance of the JSLINQ object with your data
You need to create a new JSLINQ object and pass it the javascript array of data that you will be querying.

var example = JSLINQ(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.

var whereExample1 = JSLINQ(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.

var selectTest2 = JSLINQ(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.

var sortTest1 = JSLINQ(myList)
             .OrderBy("FirstName");

var sortTest2 = JSLINQ(myList)
             .OrderBy(function(item){ return item.FirstName; });

Closed Issue: Modify "OrderBy" to accept the field/property to order by as a string

crpietschmann — Thu, 18 Jun 2009 21:01:44 GMT

Modify "OrderBy" to accept the field/property to order by as a string in addition to accepting a "clause function"/lambda expression.

Example:
var sample = JSLINQ(Samples.People)
.OrderBy("FirstName");
Comments:

Done

Source code checked in, #20736

crpietschmann — Thu, 18 Jun 2009 21:01:36 GMT

Item # 4204: Modify "OrderBy" to accept the field/property to order by as a string

Created Issue: Modify "OrderBy" to accept the field/property to order by as a string

crpietschmann — Thu, 18 Jun 2009 20:59:37 GMT

Source code checked in, #20731

crpietschmann — Thu, 18 Jun 2009 20:45:57 GMT

Added recent changes to the Change Log within the ReadMe.txt

Closed Issue: Replace "index" variable name with "i" for iterator loops in JSLINQ.js

crpietschmann — Thu, 18 Jun 2009 20:41:32 GMT

Replace "index" variable name with "i" for iterator loops in JSLINQ.js

This is just a change to help reduce the size of the script file, however insignificant it may seem.
Comments:

Done, the script file weighs in at ~6.84 KB now, however it's still uncompressed.

Commented Issue: Replace "index" variable name with "i" for iterator loops in JSLINQ.js

crpietschmann — Thu, 18 Jun 2009 20:40:18 GMT

Replace "index" variable name with "i" for iterator loops in JSLINQ.js

This is just a change to help reduce the size of the script file, however insignificant it may seem.
Comments: ** Comment from web user: crpietschmann **

fixed mispelling

Source code checked in, #20730

crpietschmann — Thu, 18 Jun 2009 20:39:51 GMT

Item # 4202: Replace "index" variable name with "i" for iterator loops in JSLINQ.js