DateTimeOffset instead of DateTime

[juergstaub]

My database has a table with a CreatedTime column of type datetime, nullable. Via RESTier I try to return this as a property of type DateTimeOffset? I receive an exception that the conversion is a problem. Then, I tried to install my own ValueConverter, but it never gets called. Lats but not least I tried to add a not mapped propterty of type DateTimeOffset to my class but I can get this one to be exposed to the service if it is not a mapped property. I am using 0.3.0-beta2.

The exception is:
The 'CreatedTime' property on 'TaskRun' could not be set to a 'System.DateTime' value. You must set this property to a non-null value of type 'System.DateTimeOffset'.

[lewischeng-ms]

Hi @juergstaub Can you try to add the following attribute to your property:

[Column("CreatedTime", TypeName = "DateTime")]
public DateTimeOffset CreatedTime {get;set;}

For installing your own converter, please inherit ODataDomainPayloadValueConverter instead of ODataPayloadValueConverter.

Related doc: http://odata.github.io/RESTier/#03-15-Date

Thanks.

[lewischeng-ms]

Related issue: #273