public async Task <IList <MediaEntity> > Query(MediaQueryModel model) { var paging = model.Paging(); var query = Db.Find(); var joinQuery = query.LeftJoin <AccountEntity>((x, y) => x.CreatedBy == y.Id); if (!paging.OrderBy.Any()) { joinQuery.OrderByDescending((x, y) => x.Id); } joinQuery.Select((x, y) => new { x, Creator = y.Name }); var result = await joinQuery.PaginationAsync(paging); model.TotalCount = paging.TotalCount; return(result); }