Why does oData V4 not order on datetime?

Question

I've created a oData V4 endpoint with Web API 2.2 and Entity Framework. The model that is expose looks like the following model:

public class Items { 
    public int Id { get; set; }
    public string Name { get; set; }
    public DateTime CreatedOn { get; set; }
}

When I go to the URL: /odata/Items it works like a charm. But when I go to the URL: /odata/Items?$orderby=CreatedOn I get the following error:

'The specified type member 'Kind' is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported.'

I have seen that post, but I got no trouble with showing the datetime. The end point gives back the correct datetime. But only when i try to order by the datetime i get this error. Did i miss a solution for this problem in that post? — C. Molendijk
Kind is a property on System.DateTime which describes whether it is Local or UTC. — Aron

Fan Ouyang Fan Ouyang · Accepted Answer · 2015-05-08T06:12:58

This is an Issue, and it's been fixed in 5.6.0 beta1, please try it, if the issue still exist, please file an issue for us :).

Why does oData V4 not order on datetime?

2 Answers