Aggregate function with a join causes client-side evaluation

[Wain123]

An entity "Blog" has a Number(28,12) column mapped to a decimal? property.
The following code:

Code: Select all

ctx.Posts.Sum(z => z.Blog.Num)

Causes Devart to select all Posts and evaluate the sum client-side instead of using an SQL statement with a SUM and a JOIN.

[Shalex]

Thank you for your report. We will investigate the issue and notify you about the result.

[Shalex]

Microsoft.EntityFrameworkCore.SqlServer behaves in the same way with EF Core v1.1.2. Look forward to upcoming EF Core v2 which should include a lot of fixes and improvements.