List ling統計関数Distinct Sum Max Average

2181 ワード

var langCount = (from s in GetStudents()                           select s.Language)                           .Distinct()                           .Count();        Response.Write(string.Format("
{0}
", langCount));        #endregion
#region用Count()のLambda式で条件を満たす要素個数Response.Write("
Count()でクエリ結果が得られた個数
");        var ageCoun = (from s in GetStudents()                          select s.Age)                          .Count(a=>a>22);        Response.Write(string.Format("
{0}
", ageCoun));        #endregion
#regionはSum()でクエリ結果をResponseに加算.Write("
はSum()でクエリ結果を加算
");        var ageSum = (from s in GetStudents()                      select s.Age)                       .Sum();        //var ageSum = GetStudents().Sum(s=>s.Age);        Response.Write(string.Format("
{0}
", ageSum));        #endregion
#regionはMin()でクエリ結果の最小値Responseを求める.Write("
はMin()でクエリ結果の最小値
");        var ageMin = (from s in GetStudents()                      select s.Age)                       .Min();        //var ageMin = GetStudents().Min(s => s.Age);        Response.Write(string.Format("
{0}
", ageMin));        #endregion
#regionはMax()でクエリ結果の最大値Responseを出す.Write("
はMax()でクエリ結果の最大値
");        var ageMax = (from s in GetStudents()                      select s.Age)                       .Max();        //var ageMax = GetStudents().Max(s => s.Age);        Response.Write(string.Format("
{0}
", ageMax));        #endregion
#regionはAverage()でクエリ結果の平均値Responseを求める.Write(「
Average()でクエリ結果の平均値
」);        var ageAverage = (from s in GetStudents()                      select s.Age)                      .Average();
 
  
var list = from it in lst
group it by it. into g
select new
{
= g.Key,
= g.Sum(p=>p. ),
};