How do I disable Sequence Number Caching in EF Core

I'm curious, so I am looking for a more elegant solution but in the meantime ... Perhaps you can get around this "sideways". Create a table just for this sequencing issue like so:

public class mySequence {
    public int sequence {get; set;}
    public bool locked {get; set;}
}

Create an index (descending) on sequence. 1) Lock sequence TABLE; 2) Find "next" unlocked sequence #; 3) If none, seed with next X sequence numbers; 4) Lock the "next" sequence #; 5) Unlock Table; 6) Use sequence # in your real data

Have to have exclusive control over some resource to mitigate collisions/duplicates.

Hm, more "elegant" solution presents itself...

Sequences using Fluent API