ODP.NET EF Core Beta 4 - Difference between two dates

1495799

Hello,

With ODP.NET EF Core Beta 4, I didn't succeed in getting a difference between two dates.

With this query :

var timeSpan = context.Requests.Select(r => DateTime.Today - r.RequestDate.Date).First();

I got the exception :

System.InvalidOperationException: 'An exception occurred while reading a database value. The expected type was 'System.TimeSpan' but the actual value was of type 'System.Decimal'.'

Inner Exception

InvalidCastException: Unable to cast object of type 'System.Decimal' to type 'System.TimeSpan'.

The type of the RequestDate column is "Date" and here is the Request class :

public class Request

{

        public Guid Id { get; set; }

public DateTime RequestDate { get; set; }

}