linQ学习--统计分组求总价和均价等

 

  Database dbSql = DatabaseFactory.CreateDatabase("server200");
  DbCommand cmd = dbSql.GetSqlStringCommand("SELECT * from [3月成交记录]");
  DataTable dt = dbSql.ExecuteDataSet(cmd).Tables[0];
  var strP = from p in dt.AsEnumerable() group p by p.Field<string>("用途") into g select new { 用途 = g.Key, 总面积 = g.Sum(p => p.Field<decimal>("成交面积")), 房间数 = g.Count(), 均价 = g.Sum(p => p.Field<decimal>("总价")) / g.Sum(p => p.Field<decimal>("成交面积")),最高价=g.Max(p=>p.Field<decimal>("总价")),最大面积=g.Max(p=>p.Field<decimal>("成交面积")) };
  dataGridView1.DataSource = strP.ToList();