Is there a built-in way to support TableGenerator ids in Entity Framework? If not, what is the best way to implement it?

Table generator doc in hibernate:

https://docs.oracle.com/javaee/6/api/javax/persistence/TableGenerator.html

Defines a primary key generator that may be referenced by name when a
generator element is specified for the GeneratedValue annotation. A
table generator may be specified on the entity class or on the primary
key field or property. The scope of the generator name is global to
the persistence unit (across all generator types).

Example 1:

@Entity public class Employee {
    ...
    @TableGenerator(
        name="empGen", 
        table="ID_GEN", 
        pkColumnName="GEN_KEY", 
        valueColumnName="GEN_VALUE", 
        pkColumnValue="EMP_ID", 
        allocationSize=1)
    @Id
    @GeneratedValue(strategy=TABLE, generator="empGen")
    int id;
    ...
}

Here is the sample implementation along with my idea for its implementation.

Create a new table in your database to store the generated keys. The table should have at least two columns: one for the key name (e.g., “Table1”) and one for the current key value.

Define a new class to represent the TableGenerator entity in your Entity Framework model. This class should map to the TableGenerator table in your database.

public class TableGenerator
{
    public string TableName { get; set; }
    public int NextId { get; set; }
}

Add a DbSet for the TableGenerator entity to your DbContext class.

public DbSet<TableGenerator> TableGenerators { get; set; }

Create a method in your DbContext class to generate a new key for a given table name.

public int GenerateKey(string tableName)
{
    var generator = TableGenerators.SingleOrDefault(t => t.TableName == tableName);
    
    if (generator == null)
    {
        generator = new TableGenerator { TableName = tableName, NextId = 1 };
        TableGenerators.Add(generator);
    }
    
    generator.NextId++;
    
    SaveChanges();
    
    return generator.NextId;
}

Use the GenerateKey method to generate unique keys for your entities.

var newId = dbContext.GenerateKey("Table1");

var entity = new MyEntity { Id = newId, Name = "Entity1" };

dbContext.MyEntities.Add(entity);
dbContext.SaveChanges();

How can the above code be improved and a locking mechanism added?