linq頭腦風暴001_彙總函式

   求最大值Max()
   最小值Min()
   平均值Average()
   總個數Count()
   求和Sum()

1、實體Bean

    public class Tuzi    {        public int Id { get; set; }        public int Age { get; set; }        public string Name { get; set; }    }

2、實體初始化器

  static List<Tuzi> InitTuziInfo()        {            List<Tuzi> tuziList = new List<Tuzi> {              new Tuzi{ Name="Tuzi001", Age=10  },             new Tuzi{ Name="Tuzi002", Age=24 },             new Tuzi{ Name="Tuzi003", Age=33  },             new Tuzi{ Name="Tuzi004", Age=47  },             new Tuzi{ Name="Tuzi005", Age=59 },             new Tuzi{ Name="Tuzi006", Age=65  },             new Tuzi{ Name="Tuzi007", Age=76  },             new Tuzi{ Name="Tuzi008", Age=80  }              };            return tuziList;        }

3、結果

 

 static void Main(string[] args)        {            List<Tuzi> tuziList = InitTuziInfo();            #region 001 彙總函式            int maxAge = (from s in tuziList                          select s).Max(a => a.Age);            Console.WriteLine("年齡最大的是:" + maxAge);            //Lambda 形式            int minAge = tuziList.Select(a => a.Age).Min();            //==>編輯為            //minAge = tuziList.Select<Tuzi, int>(delegate(Tuzi t)            //{            //    return t.Age;            //}).Min();            Console.WriteLine("年齡最小的是:" + minAge);            int avgAge = (int)tuziList.Select(a => a.Age).Average();            Console.WriteLine("年齡平均為:" + avgAge);            avgAge = (int)tuziList.Where(a => a.Age != maxAge && a.Age != minAge).Average(a => a.Age);            Console.WriteLine("去除最高，最低後的年齡平均為:" + avgAge);            int ageCount = (int)tuziList.Select(a => a.Age).Count();            Console.WriteLine("年齡總個數為:" + ageCount);            int ageSum = (int)tuziList.Select(a => a.Age).Sum();            Console.WriteLine("年齡和為:" + ageSum);            #endregion                Console.ReadKey();        }