C#基础之LINQ语法解析

LINQ类似于SQL语句，在C#这里可以支持对象，数据库，XML，JSON等。

1.用法如下

1> from...in... 指定要查找的数据源以及范围变量

List<string> names = new List<string>() {"Tom","Lili","Gay"};

            var nameList = from name in names where name[0] == 'T' select name;
            foreach (var VARIABLE in nameList)
            {
                Console.WriteLine(VARIABLE);
            }

2> orderby descending 排序

List<int> ages = new List<int>() {1,5,10,7,20,57,39};

            var selectAge = from age in ages
                            where age > 10
                            orderby age descending
                            select age;

            foreach (var i in selectAge)
            {
                Console.WriteLine(i);
            }

3> where 条件，可以用&&或者||等

4> group 分组