Create an alternate key for join entity types which have an independent PK
Nobody has claimed this yet.
Assessment
- Difficulty
- 5/5
- Estimated time
- Over a week
- Newbie friendliness
- 35/100
- Issue type
- Feature
- Clarity
- Mostly clear
- Activity status
- Stale
- Tech stack
- csharp
- Domain
- backend-api-design, databases
Research direction
Start with the state manager's fixup path and how join entity types are identified, using the example in this issue as the target case. Review issue #4073 before designing the dependency. Done means join types with an independent primary key have an alternate key for the usual composite join values and support fast matching during fixup.
Written by the indexing model from the issue text.
Description
Consider this many-to-many join type:
public class JoinType
{
public virtual Guid Id { get; set; }
public virtual int LeftId { get; set; }
public virtual int RightId { get; set; }
}
When performing fixup, the state manager needs to lookup instance where LeftId and RightId match. This fast when these types form the composite PK of the type. In this case Id is the PK, and hence there isn't a way to do a fast lookup for matches of LeftId and RightId.
To fix this, we should create an alternate key for what would usually be the PK in the join table. However, we should likely only do this after #4073 is implemented to avoid making it impossible to change these values, although it does seem unlikely that changing them would be useful.
- Dominant language
- C#
- Stars
- 14.8k
- Forks
- 3.4k
- Avg merge
- 2d 5h
- Merged PRs (30d)
- 134
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from dotnet/efcore
-
Difficulty 4/5 3-5 days Newbie friendliness 55/100
-
customer-reported
Difficulty 5/5 Over a week Newbie friendliness 38/100
-
area-cosmos area-vector-search
Difficulty 5/5 Over a week Newbie friendliness 25/100
-
area-cosmos
Difficulty 5/5 Over a week Newbie friendliness 25/100
-
area-tools needs-design
Difficulty 4/5 3-5 days Newbie friendliness 25/100
Similar issues
-
Difficulty 2/5 1-3 hours Newbie friendliness 86/100
-
:watch: Not Triaged 11.0 fundamentals/subsvc
Difficulty 2/5 1-3 hours Newbie friendliness 92/100
dotnet/AspNetCore.Docs#37699 ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 72/100
SubtitleEdit/subtitleedit#15108 · 1 comment ·
-
area/docs-content Bug pulumi/docs
Difficulty 1/5 1-3 hours Newbie friendliness 94/100
-
agentic-workflows untriaged
Difficulty 2/5 1-3 hours Newbie friendliness 76/100