RavenDB Query does not return all records

Question

I am trying to get back all of the objects which I have saved in the database but not all of them come back:

var everything = session.Query<MyObject>()
                        .Where(x => !x.IsDeleted &&
                                     x.WorkflowStatus == WorkflowStatus.Published);

I have 206 objects in total, a good 80% of them fit the criteria above but only 127 are returned.

Can anyone see why?

Answer 1

By default, queries return up to 128 records.

Use an explicit Take(n) to get more records.