Can odata total records be found without fetching them?

Question

Am creating paging and fetching 10 JSON records per page:

  var coursemodel = query.Skip(skip).Take(take).ToList();

I need to display on the web page the total number of records available in database. For example, you are viewing 20 to 30 of x (where x is total number of records). Can x be found without transferring the records over the network?

Answer 1

Sorted it. Did this

http://yourserver7:40479/odata/Courses?$top=1&skip=1&$inlinecount=allpages

Got this

 {
  "odata.metadata":"http://yourserver7:40479/odata/$metadata#Courses","odata.count":"503","value":[
    {
      "CourseID":20,"Name":"Name 20","Description":"Description 20","Guid":"Guid 20"
    }
  ]
}

I then got the value from odata.count! My url gets all records found, add $filter where applicable...

Answer 2

You can use the $count operator to return the total number of records, something along these lines:

http://services.odata.org/OData/OData.svc/Categories(1)/Products/$count

Not sure what the syntax would be with Linq, but pretty sure it is possible.

PS - Always a good reference: http://www.odata.org/documentation/odata-version-2-0/uri-conventions/