Why can't we use DbBlockIdGenerator on Sqlite?

[hyzx86]

I've checked the code, why don't we also use DbBlockIdGenerator in Sqlite?

I would love to be able to reuse this functionality, such as adding autoid to a specified function module or field, but DefaultIdGenerator needs to qualify specific tables

https://github.com/sebastienros/yessql/blob/main/src/YesSql.Core/Services/DbBlockIdGenerator.cs

OrchardCore/src/OrchardCore/OrchardCore.Data.YesSql/OrchardCoreBuilderExtensions.cs

Lines 69 to 98 in 5a472d4

	case DatabaseProviderValue.SqlConnection:
	storeConfiguration
	.UseSqlServer(shellSettings["ConnectionString"], IsolationLevel.ReadUncommitted, shellSettings["Schema"])
	.UseBlockIdGenerator();
	break;
	case DatabaseProviderValue.Sqlite:
	var shellOptions = sp.GetService<IOptions<ShellOptions>>().Value;
	var sqliteOptions = sp.GetService<IOptions<SqliteOptions>>().Value;
	var databaseFolder = SqliteHelper.GetDatabaseFolder(shellOptions, shellSettings.Name);
	Directory.CreateDirectory(databaseFolder);
	var connectionString = SqliteHelper.GetConnectionString(sqliteOptions, databaseFolder);
	storeConfiguration
	.UseSqLite(connectionString, IsolationLevel.ReadUncommitted)
	.UseDefaultIdGenerator();
	break;
	case DatabaseProviderValue.MySql:
	storeConfiguration
	.UseMySql(shellSettings["ConnectionString"], IsolationLevel.ReadUncommitted, shellSettings["Schema"])
	.UseBlockIdGenerator();
	break;
	case DatabaseProviderValue.Postgres:
	storeConfiguration
	.UsePostgreSql(shellSettings["ConnectionString"], IsolationLevel.ReadUncommitted, shellSettings["Schema"])
	.UseBlockIdGenerator();
	break;
	default:
	throw new ArgumentException("Unknown database provider: " + shellSettings["DatabaseProvider"]);
	}

[sebastienros]

Have you checked in YesSQL if there is a comment explaining the reason?

[hyzx86]

I didn't find any instructions for that 😢