Aggregate function with a join causes client-side evaluation

Discussion of open issues, suggestions and bugs regarding Entity Framework support in ADO.NET Data providers
Post Reply
Wain123
Posts: 12
Joined: Wed 07 Jun 2017 07:25

Aggregate function with a join causes client-side evaluation

Post by Wain123 » Thu 06 Jul 2017 13:07

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
Site Admin
Posts: 8247
Joined: Thu 14 Aug 2008 12:44

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

Post by Shalex » Tue 11 Jul 2017 19:18

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

Shalex
Site Admin
Posts: 8247
Joined: Thu 14 Aug 2008 12:44

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

Post by Shalex » 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.

Post Reply