static void QueryStrings()
        {
string[] games = { "Morrowind", "Uncharted 2", "Fallout 3", "Daxter", "Shock2" };
//构建一个查询表达式(注意：ling表达式在迭代内容之前，他们不会真正的运行计算)//linq此时还没有运算
//linq查询的结果集，应该总是使用隐式类型，在绝大数情况下，真正的返回值实现了泛型 IEnumerable<T>接口的类型
            var subset = from g in games where g.Contains(" ") orderby g select g;
//上面代码也可以写成 IEnumerable<string> subset = from g in games where g.Contains(" ") orderby g select g; 
//输出结果。在迭代的时候才运算（这叫：延迟执行）
            foreach (string s in subset)
            {
                Console.WriteLine("含有空格的是：{0}",s);
            }
        }

       //在foreach逻辑外运算linq
        static void QueryInt()
        {
//如果希望在foreach逻辑外表运算Linq表达式，可以调用有Enumerable类型定义的扩展方法。如ToArray<T>()、ToList<T>()等。
            int[] numbers = { 2, 10, 30, 15, 1, 22 };
//立即获取数据
            int[] rst =( from i in numbers where i >10 orderby i select i).ToArray<int>();

        }

        static void FunLinq()
        {
int[] numbers = { 2, 10, 30, 15, 1, 22 };
//输出大于10的总数
            int count = (from i in numbers where i > 10 orderby i select i).Count<int>();
            Console.WriteLine(count);//输出：3
        }

      var newnumbers = from i in numbers select i;
foreach (var p in numbers.Reverse())
            {
                Console.WriteLine(p);//输出22 1 15 30 10 2
            }

       //排序(正序)
            string[] games = { "Morrowind", "Uncharted 2", "Fallout 3", "Daxter", "Shock2" };
            var newn = from i in games orderby i ascending select i;
foreach (var p in games)
            {
                Console.Write(p+",");//
            }

   //排序(正序)
            string[] games = { "Morrowind", "Uncharted 2", "Fallout 3", "Daxter", "Shock2", "Shock2"};
            var newn = from i in games orderby i ascending select i;
foreach (var p in games.Disinct())
            {
                Console.Write(p+",");//
            }

//聚合操作
//最大值
            var maxi =( from i in games orderby i ascending select i).Max();
//最小值
            var mini = (from i in games orderby i ascending select i).Min();
//平均值
            var avar = (from i in numbers orderby i ascending select i).Average();
//总和
            var sum = (from i in numbers orderby i ascending select i).Sum();