随笔-.NET MVC LINQ常用注意

1】linq根据自定字段去重复【关键词 GroupBy、Select】

 var List = (from a02 in a02List.Where(c => true)
                            join a01 in a01List.Where(c => true) on a02.Id equals a01.Id
                            j select new
                            {
                                a01.Name,
                                a01.Id,
                                a01.Sort,
                            }).GroupBy(r => r.Id).Select(r => r.First()) .ToList();

[获取重复中的第一个]

2】linq中将base[]转化为string  【guanjiAsEnumerable()】

 var List = (from a02 in a02List.Where(c => true)
                            join a01 in a01List.Where(c => true) on a02.Id equals a01.Id
                              select new
                            {
                                a01.Name,
                                a01.Id,
                                a01.Sort,
                                a02.pImgByte
                            }).AsEnumerable().Select(x => new {
                                x.Name,
                                x.Id,
                                x.Sort,
                                pImgByteArr =  x.pImgByte != null ? System.Text.Encoding.Default.GetString( x.pImgByte) : ""

                            }).ToList();