Sum over owned collection with property selector in nested Select inside SelectMany cannot be translated #35467
Assignees
Labels
Comments
|
Confirmed. Minimal reproawait using var context = new BlogContext();
await context.Database.EnsureDeletedAsync();
await context.Database.EnsureCreatedAsync();
_ = await context.Set<Blog>()
.SelectMany(b => b.Posts.Select(p => p.Comments.Sum(c => c.Likes.Amount)))
.ToListAsync();
public class BlogContext : DbContext
{
public DbSet<Blog> Blogs { get; set; }
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
=> optionsBuilder
.UseSqlServer("Server=localhost;Database=test;User=SA;Password=Abcd5678;Connect Timeout=60;ConnectRetryCount=0;Encrypt=false")
.LogTo(Console.WriteLine, LogLevel.Information)
.EnableSensitiveDataLogging();
}
public class Blog
{
public int Id { get; set; }
public ICollection<Post> Posts { get; set; } = null!;
}
public class Post
{
public int Id { get; set; }
public ICollection<Comment> Comments { get; set; } = null!;
}
[Owned]
public class CommentLikes
{
public int Amount { get; set; }
}
[Owned]
public class Comment
{
public CommentLikes Likes { get; set; } = null!;
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Bug description
From what I saw it seems that the bug is somewhere in
NavigationExpandingExpressionVisitor, where it is causing the Sum expression to pass fromc => c.Likes.Amounttoo => Property(o, "Likes").Amountfirst and theno0 => Property(o, "Likes").Amount. So it seems that somewhere the new argument of the lambda is not being replaced inside the previous lambda body.Your code
Stack traces
EF Core version
8.0.11
Database provider
Microsoft.EntityFrameworkCore.SqlServer
Target framework
.NET 8.0
Operating system
Windows 10
IDE
Visual Studio 2022 17.11.4
The text was updated successfully, but these errors were encountered: