In microsoft.entityframeworkcore.sqlserver has ForSqlServerUseSequenceHiLo extend method that allows you to use HiLo to generate keys with Entity Framework Core. How using HiLo to generate keys with Pomelo.EntityFrameworkCore.MySql?
Library Pomelo.EntityFrameworkCore.MySql currently does not support the HiLo algorithm to generate keys, but use HiLo algorithm on MySql possible, for example, using the nuget package NHiLo.