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, May 03 '15 at 13:23
Kind is a property on `System.DateTime` which describes whether it is Local or UTC. — Aron, May 03 '15 at 13:30

score 0 · Accepted Answer · edited May 23 '17 at 12:09

OData v4 doesn't suport DateTime type. You should use DateTimeOffset instead. That's because of problems that can happen if you don't specify the time zone. In fact there is an open discussion if it shuld be supported or not.

Please, see this references:

If you check those issues, you'll find that support for DateTime has been added to version 5.6.0 beta 1.

score 0 · Answer 2 · answered May 08 '15 at 06:12

0

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 :).

answered May 08 '15 at 06:12

Fan Ouyang

2,132
1
11
13

Why does oData V4 not order on datetime?

2 Answers2

Linked