Linq如何去除重复值问题

Question

var data = (from u in _stone_storageService.LoadSearchData(roleQuery).AsEnumerable()
select new
{
u.ID ,
datetime = u.datetime.ToString(),
u.S_Number,
u.Settlement_Method,
u.supplier,
u.R_Amount,
u. Approval_Status ,
u.founder,
u.reviewer,
u.subject
});

        //构造成Json的格式传递
         var result = new { total = Math.Ceiling(Convert.ToDouble(roleQuery.Total * 1.0 / pageSize)), rows = data, records = roleQuery.Total };
        //var result = new { total = Math.Ceiling(Convert.ToDouble(data1.Count() * 1.0 / pageSize)), rows = data1, records = data1.Count() };
        return Json(result, JsonRequestBehavior.AllowGet);

                    以S_Number字段去除重复值，其余字段可以有重复值。
                    求大神指教！！！

Answer 1

var data = (from u in _stone_storageService.LoadSearchData(roleQuery).AsEnumerable()
.GroupBy(x => x.S_Number).Select(x => x.First())