Linq to sql - GroupBy
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif)
protected IList<String> SelectTitleList() { using (SamjinDBDataContext db = new SamjinDBDataContext()) { IList<String> returnList = new List<String>(); var list = from v in db.View_Design_History group v by v.Title into g select new { // g.key 是 v.Title 值 Title = g.Key }; foreach (var item in list) { returnList.Add(item.Title); } return returnList; } }