• linq count() sum() Min() Max() Average() 用法


    #region 用Count()得出查询结果的个数
    Response.Write("<hr>用Count()得出查询结果的个数<br>");
    var langCount = (from s in GetStudents()
    select s.Language)
    .Distinct()
    .Count();
    Response.Write(string.Format("<div class='result'>{0}</div>", langCount));
    #endregion
    #region 用Count()的Lambda表达式满足条件的元素个数
    Response.Write("<hr>用Count()得出查询结果的个数<br>");
    var ageCoun = (from s in GetStudents()
    select s.Age)
    .Count(a=>a>22);
    Response.Write(string.Format("<div class='result'>{0}</div>", ageCoun));
    #endregion
    #region 用Sum()将查询结果相加
    Response.Write("<hr>用Sum()将查询结果相加<br>");
    var ageSum = (from s in GetStudents()
    select s.Age)
    .Sum();
    //var ageSum = GetStudents().Sum(s=>s.Age);
    Response.Write(string.Format("<div class='result'>{0}</div>", ageSum));
    #endregion
    #region 用Min()得出查询结果的最小值
    Response.Write("<hr>用Min()得出查询结果的最小值<br>");
    var ageMin = (from s in GetStudents()
    select s.Age)
    .Min();
    //var ageMin = GetStudents().Min(s => s.Age);
    Response.Write(string.Format("<div class='result'>{0}</div>", ageMin));
    #endregion
    #region 用Max()得出查询结果的最大值
    Response.Write("<hr>用Max()得出查询结果的最大值<br>");
    var ageMax = (from s in GetStudents()
    select s.Age)
    .Max();
    //var ageMax = GetStudents().Max(s => s.Age);
    Response.Write(string.Format("<div class='result'>{0}</div>", ageMax));
    #endregion
    #region 用Average()得出查询结果的平均值
    Response.Write("<hr>用Average()得出查询结果的平均值<br>");
    var ageAverage = (from s in GetStudents()
    select s.Age)
    .Average();
    //var ageAverage = GetStudents().Average(s => s.Age);
    Response.Write(string.Format("<div class='result'>{0}</div>", ageAverage));
    #endregion
  • 相关阅读:
    【CentOS】CentOS7开放及查看端口
    【nginx】配置https 证书生成的方法
    【MacOs】 Royal TSX SSH 和 FTP 中文乱码
    【PHP】thinkphp3.2.5
    【TCP/IP】入门学习笔记 五
    【TCP/IP】入门学习笔记 四
    HTTP
    【PHP】高并发和大流量的解决方案(思路)
    react多级路由 重定向与404定义
    react自定义导航组件 路由参数
  • 原文地址:https://www.cnblogs.com/yannis/p/2311770.html
Copyright © 2020-2023  润新知