EF 复杂语句的使用

//EF多重排序
context.Serials
                      .Where(s => ("," + s.VideoGenreIds + ",").Contains("," + genreIds + ",") && s.IsEnable && !s.IsDel)
                      .OrderByDescending(v => v.Weight)
                      .ThenByDescending(v => v.Hot)
                      .Skip((currentPage - 1) * pageSize)
                      .Take(pageSize)
                      .Select(v => new SerialBriefModel
                      {
                          Id = v.Id,
                          SerialName = v.SerialName,
                          LastEpisode = v.LastEpisode,
                          Description = v.Description,
                          PicturePath = v.PicturePath,
                          AddTime = v.AddTime
                      }).ToList();



//EF group的使用以及 两表连接


var model = context.Serials
                     .Where(s => s.Id == serialId && s.IsEnable && !s.IsDel)
                     .GroupJoin(context.SerialEpisodes.Where(e=>!e.IsDel), s => s.Id, e => e.SerialId, (s, e) 
                     => new SerialDetailModel
                     {
                         Id = s.Id,
                         SerialName = s.SerialName,
                         VideoAreaId = s.VideoAreaId,
                         VideoAreaName = s.VideoArea.AreaName,
                         VideoGenreIds = s.VideoGenreIds,
                         VideoLanguageId = s.VideoLanguageId,
                         VideoLanguageName = s.VideoLanguage.Language,
                         TotalEpisodes = s.TotalEpisodes,
                         LastEpisode = s.LastEpisode,
                         Director = s.Director,
                         Starring = s.Starring,
                         ReleaseYear = s.ReleaseYear,
                         PicturePath = s.PicturePath,
                         Description = s.Description,
                         Fee = s.VideoChargeMethod.Fee,
                         Hot = s.Hot,
                         Score = s.Score,
                         SerialEpisodes = e.OrderBy(se => se.SerialIndex).Select(se => new SerialEpisodeModel
                         {
                             Id = se.Id,
                             SerialIndex = se.SerialIndex,
                             TagName = se.SerialTag.TagName,
                             Title = se.Title,
                             Description = se.Description
                         }
                         ).ToList()
                     }).FirstOrDefault();

 

转载于:https://www.cnblogs.com/zoro-zero/p/5238675.html