linqjs试用

var data = {
    customers: [{
        id: 1,
        firstname: 'John',
        lastname: 'Smith',
        sex: 'male'
    }, {
        id: 2,
        firstname: 'Jessica',
        lastname: 'Johnson',
        sex: 'female'
    }, {
        id: 3,
        firstname: 'Michael',
        lastname: 'Williams',
        sex: 'male'
    }, {
        id: 4,
        firstname: 'Amber',
        lastname: 'Davis',
        sex: 'female'
    }],
    address: [{
        id: 1,
        address: 'ynkm'
    }, {
        id: 2,
        address: 'ynyx'
    }]
};

var enumerable=Enumerable.from(data.customers);

enumerable.groupBy("$.firstname.charAt(0)", "x=>x.firstname").forEach(function(group) {
    console.log(group.key());
    group.forEach(function(aaa) {
        console.log(aaa);
    });
});


enumerable.groupBy("$.firstname.charAt(0)",  "","key,group=>key+'-'+group.select('$.firstname').toJoinedString(',')").forEach(function(group) {
    console.log(group);
});

enumerable.toLookup("$.sex","$.firstname").toEnumerable().forEach(function(group) {
    console.log(group.key());
    group.orderBy().forEach(function(aaa) {
        console.log(aaa);
    });
});

console.log(enumerable.toDictionary("$.firstname").get("Richard"));
console.log(enumerable.toObject("$.firstname")["Richard"]);

var enumerable2=Enumerable.from(data.address);
//inner join
enumerable.join(enumerable2, "$.id", "$.id", "outer,inner=>{'id':outer.id,'firstname':outer.firstname,'address':inner.address}").forEach(function(aaa) {
    console.log(aaa);
});

enumerable.groupJoin(enumerable2, "$.id", "$.id", "outer,inner=>{'id':outer.id,'firstname':outer.firstname,'address':inner&&inner.address||''}").forEach(function(aaa) {
    console.log(aaa);
});