OrmLite db.Select not return response

Question

I use Servietack and OrmLite in our project. When the request (Db.Select) is sent, after much time, no response return.

       public object Get(GetCategoryNews request)
        {
            var PageCount = 20;
            var skip = (request.Page.GetValueOrDefault(1) - 1) * PageCount;

            var cacheKey = UrnId.Create<GetCategoryNews>(DateTime.Now.ToString("yyMMddhhmm") + skip);
            return base.Request.ToOptimizedResultUsingCache(base.Cache, cacheKey, () =>
            {
            //On this line, waiting and no response
              var status = Db.Select<News>().Skip(skip).Take(PageCount).Select(o => new NewsResponse() {
                    Id = o.Id,
                    CreateOn = o.CreateOn,
                    Description = o.Description,
                    PublishOn = o.PubDate,
                    Title = o.Title
                });
                return status;
            });
        }

but when Count request, It work well

    var count = Db.Count<News>();

How do I fix this?

mythz · Accepted Answer · 2017-04-22 18:30:43Z

2

Calling Db.Select<News>() returns a List<News> which downloads your entire table results into an in memory list collection. Since you're trying to page the resultset you need to instead build an SqlExpression that OrmLite executes to only return the results you're interested in, e.g:

//Create SQL Query
var q = db.From<News>()
          .Skip(skip)
          .Take(PageCount);

var results = db.Select(q); //Executes paged query
return results.Select(o => new NewsResponse {
    Id = o.Id,
    CreateOn = o.CreateOn,
    Description = o.Description,
    PublishOn = o.PubDate,
    Title = o.Title
});

answered Apr 22, 2017 at 18:30

mythz

144k31 gold badges253 silver badges400 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

AmirHossein Over a year ago

thanks guy, How can I query in nested objects, for example = var q = Db.From<News>() .Where(o => o.Feed.Category.CategoryId == 10);

mythz Over a year ago

@AmirHossein Please don't put code in comments, can you ask a new question.

mythz Over a year ago

@AmirHossein That's likely not the answer you want, you can use Typed Where Expression.

Collectives™ on Stack Overflow

OrmLite db.Select not return response

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related