dotnet / dotnet/efcore

GroupBy JSON Entity

Open
#29,011 0 comments 0 reactions 0 assignees View on GitHub
area-groupby area-json area-query needs-design
Dominant language
C#
Stars
14.8k
Forks
3.4k
PR merge metrics
PR metrics pending

Description

Variation for #17653

When grouping by an entity, we add all the columns of the entity in the grouping key.
For entity which are mapped as JSON,
- Should we add all the properties? If yes, how would we add the ordinal property which is non-persisted.
- Given the JSON entity is going to be single SQL function call, we can just add the function call.

First option aligns with regular entity but would cause a lot of JSON scalar function calls. Second option will only have one call but the grouping key will contain owned entities in aggregate too. Further, grouping by a large JSON blob may not be something which user should do.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.