好久不写东东了,最近做linq分组统计的时候有点麻烦,用了一天时间才都到自己想要的效果,以下是entity framework的分组统计:
IQueryable<Entity.Class1> mm = null;
Entity.Class1 ma = new Entity.Class1();
mm = from t in context.Subject group t by t.StudentName into m select new Entity.Class1{ ID = m.Key, UserID = m.Count(), UserType =m.Sum(p => p.Grade) };
GridView1.DataSource = mm;
其中Entity.Class1是一个自定义的用于存放SELECT出来的数据
public class Class1
{
public Class1()
{ }
private string _ID;
private decimal? _UserType;
private decimal _UserID;
/// <summary>
/// 索引
/// </summary>
public string ID
{
get { return _ID; }
set { _ID = value; }
}
/// <summary>
/// 用户类型
/// </summary>
public decimal? UserType
{
get { return _UserType; }
set { _UserType = value; }
}
public decimal UserID
{
get { return _UserID; }
set { _UserID = value; }
}
}
以上是用于测试随便写写的,没有整理,不过这是这样的思路了