EntityFrameworkCore Scaffolding: Increase maximum identifier lenght for Firebird 4.0

[bgrauer-atacom]

The maximum identifier length has changed from 31 characters in version 3 to 63 characters in version 4.

The FbConventionSetBuilder has a RelationalMaxIdentifierLengthConvention which is still set to 31. This can lead to unwanted name cuts when using Scraffolding.

[cincuranet]

Duplicate of https://github.com/FirebirdSQL/NETProvider/issues/931.

[bgrauer-atacom]

There is a workaround which can be applied to the DbContext to increase the length:

    protected override void ConfigureConventions(ModelConfigurationBuilder configurationBuilder)
    {
        base.ConfigureConventions(configurationBuilder);
        configurationBuilder.Conventions.Replace((services) =>
        {
            var dependencies = services.GetRequiredService<ProviderConventionSetBuilderDependencies>();
            var relationalDependencies = services.GetRequiredService<RelationalConventionSetBuilderDependencies>();
            return new RelationalMaxIdentifierLengthConvention(63, dependencies, relationalDependencies);
        });
    }