Linq to sql - GroupBy

View Code
 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;
            }
        }

 

posted @ 2012-10-17 09:36  jungil  阅读(126)  评论(0编辑  收藏  举报