List ling統計関数Distinct Sum Max Average
2181 ワード
var langCount = (from s in GetStudents() select s.Language) .Distinct() .Count(); Response.Write(string.Format("
#region用Count()のLambda式で条件を満たす要素個数Response.Write("
Count()でクエリ結果が得られた個数
"); var ageCoun = (from s in GetStudents() select s.Age) .Count(a=>a>22); Response.Write(string.Format("
#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("
#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("
#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("
#regionはAverage()でクエリ結果の平均値Responseを求める.Write(「
Average()でクエリ結果の平均値
」); var ageAverage = (from s in GetStudents() select s.Age) .Average();
{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. ),
};