dotnet / dotnet/efcore

JSON/Query: translate groupby followed by orderby json scalar + FirstOrDefault

Open
#29,287 0 comments 1 reaction 0 assignees View on GitHub
area-groupby area-json
Dominant language
C#
Stars
14.8k
Forks
3.4k
PR merge metrics
PR metrics pending

Description

Something like:

```cs
ss.Set()
.GroupBy(x => x.OwnedReferenceRoot.OwnedReferenceBranch.Enum)
.Select(g => g.OrderBy(x => x.OwnedReferenceRoot.Number).FirstOrDefault())
```

this should work since OwnedReferenceRoot.Number doesn't need nav expansion, just JSON_VALUE call

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.