After enabling queryable support in ASP.NET Web API $count is not working

Question

I am working on a Web API application where we have enabled the queryable support in ASP.NET Web API.

Issue: $skip, $top etc are working but $count & $inlineCount is not working.

My API controller is not derived from ODataController, looks like below

public class UsersSvcController : ApiController

[Queryable]
public IQueryable<VMUser> Get()
{
        return userBL.GetAll();
}
}

I came to know that Odata is not supported with Generic type as of now and so $count is also not working.

Is there any way where I can extend QueryableAttribute class and write my own code to get the total records?

Feng Zhao Feng Zhao · Accepted Answer · 2014-05-30T10:00:53

Since you are not using ODataController, the "count" won't be serialized into response payload.

The "count" serialization is done in the ODataFeedSerializer.

If you want the "count" in the response payload, you need to use ODataController.

If you just need the "count" value, you can get it from the response as blow.

1.For V3:

response.RequestMessage.Properties.TryGetValue("MS_InlineCount", out countValue)

Or use extension method under namespace "System.Web.Http.OData.Extensions"

response.RequestMessage.ODataProperties().TotalCount

2.For V4:

response.RequestMessage.Properties.TryGetValue("System.Web.OData.TotalCount", out countValue)

Or use extension method under namespace "System.Web.OData.Extensions"

response.RequestMessage.ODataProperties().TotalCount