Devart Forums

Posted: **Thu 06 Jul 2017 13:07**

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

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.

Posted: **Tue 11 Jul 2017 19:18**

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

Posted: **Wed 02 Aug 2017 18:02**

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.

Devart Forums

Aggregate function with a join causes client-side evaluation

Aggregate function with a join causes client-side evaluation

Re: Aggregate function with a join causes client-side evaluation

Re: Aggregate function with a join causes client-side evaluation