How do I ensure sequential document numbering using EF Core with a SQL database?
I have a simple application that must assign a sequential number without gaps or duplicates to each Document that is created i.e. 1, 2, 3 etc. A different document type will have a different numering sequence.