Specified cast is not valid

[capesean]

In my example, I have a Time class with a Minutes field defined using the short data type.

If I try to get the total decimal hours like this:
var totalHours = _dbContext.Times.Sum(t => t.Minutes / 60m);

I get the error:

An exception of type 'System.InvalidCastException' occurred in EntityFramework.Core.dll but was not handled in user code. Additional information: Specified cast is not valid.

This, however, works fine:
var totalHours = _dbContext.Times.Sum(t => t.Minutes / 60);

[capesean]

Can someone tell me if this is a bug? It just seems too simple to be an undocumented issue, but it's cropping up everywhere in my project.

[capesean]

This seems to work:

var test = _dbContext.Times.Sum(t => (decimal?)Convert.ToDecimal(t.Minutes) / 60m);

I suppose it makes sense - you have to explicitly convert it to a decimal to get EF to do so. EF6 was able to infer this I guess. I need the (decimal?) in case there are no times, but that's not necessary for this particular issue. I just wanted to show that it looks a bit odd to have to cast twice. But I can live with that.