Linq 分组或者去重

   public List<fuction> Getlist(string School)
        {
            Db_Jst_ChatgroupDataContext S_Info = new Db_Jst_ChatgroupDataContext();
            IQueryable<fuction> item = from G_info in S_Info.Group_Info1
                                       from G_School in S_Info.Group_SchoolInfo
                                       where G_info.Gschool.Equals(School)
                                       select new fuction
                                       {
                                           省份 = G_info.Gprovince,
                                           学校 = G_info.Gschool,
                                           班级 = G_info.GroupName,
                                           联系人 = G_School.Contact,
                                           联系邮箱 = G_School.Email,
                                           联系电话 = G_School.Tel
                                       };
            return item.ToList();
        }

[最优解释]
本帖最后由 q107770540 于 2012-11-13 17:51:11 编辑

public class FuctionComparer : IEqualityComparer<fuction>  
    {   
 
        public bool Equals(fuction f1, fuction f2)  
        {  
            return (f1.省份 == f2.省份 && f1.学校 == f2.学校);  
        }  
        public int GetHashCode(fuction t)  
        {  
            return t.ToString().GetHashCode();  
        }  
    }  

return item.ToList().Distinct(new FuctionComparer ());

[其他解释]
public List<fuction> Getlist(string School)
{
Db_Jst_ChatgroupDataContext S_Info = new Db_Jst_ChatgroupDataContext(); IQueryable<fuction> item = from G_info in S_Info.Group_Info1 from G_School in S_Info.Group_SchoolInfo
where G_info.Gschool.Equals(School)
select new fuction
{
省份 = G_info.Gprovince,
学校 = G_info.Gschool,
班级 = G_info.GroupName,
联系人 = G_School.Contact,
联系邮箱 = G_School.Email,

联系电话 = G_School.Tel
};
return item.Distinct().ToList();
}
[其他解释]
上面查询出来为什么会出现重复的行,求解.
如果消除重复行,代码应该怎么改.
如果利用分组来消除重复,分组的格式是怎么样的
[其他解释]
linq有distinct函数
[其他解释]

引用:

linq有distinct函数

我的应该加在哪里？
[其他解释]
参考：
http://blog.csdn.net/q107770540/article/details/5784646

[其他解释]
[quote=引用:]

return item.ToList().Distinct(new FuctionComparer ());//?
[quote]
我的应该怎样写哦, return item.ToList().Distinct(new fuction());这样写不对哦
[其他解释]

引用:

本帖最后由 q107770540 于 2012-11-13 17:51:11 编辑


C# code?



12345678910111213

public class FuctionComparer : IEqualityComparer<fuction> { public bool Equals(fuction f1, fuction f……

帮我改下我的啊,接触Linq时间不长,看不懂
[其他解释]

引用:

public List<fuction> Getlist(string School)
{
Db_Jst_ChatgroupDataContext S_Info = new Db_Jst_ChatgroupDataContext(); IQueryable<fuction> item = from G_info i……

请教下,分组应该写在哪里？用G_School.Contact来分组应该怎么写
[其他解释]
求来人...