More info needed on primary key configuration?

[fterrani]

Type of issue

Missing information

Description

Greetings.

Currently, there seem to be no information about how exactly the SQLite EF Core provider configures primary keys. SQLite has several ways to handle primary keys (I know there are at least ROWID only, ROWID with AUTOINCREMENT and ROWID-less tables but there might be other cases). I'm mainly thinking of integral single-column primary keys in my use case.

Would you be willing to document this?

It would also be interesting to know what happens when using other kinds of keys (e.g. Guid keys, other non-integral keys, composite keys), although this is probably much less critical.

Page URL

https://learn.microsoft.com/en-us/ef/core/providers/sqlite/?tabs=dotnet-core-cli

Content source URL

https://github.com/dotnet/EntityFramework.Docs/blob/main/entity-framework/core/providers/sqlite/index.md

Document Version Independent Id

55c2150e-2afa-0dca-0db6-9a5105312e73

Platform Id

87378869-871f-c945-5611-342d9430cfd6

Article author

@SamMonoRT

[roji]

We have PR #5115 pending on exactly this - take a look there.

[fterrani]

Perfect! :) Thanks for pointing me to this PR.