How to configure MaxIdentifierLength constant in EF Core 2.1?

Question

After upgrade from EF 2.0 to 2.1 we found that new migration recreates FKs and indexes in some strange manner shrinking their names to 63 chars. Also, the MaxIdentifierLength attribute was present in the top of migration file. I made some research and did not find how to configure that length default.

Answer 1

Currently there is no fluent API for that.

But it can be accessed via RelationalModelAnnotations class:

var maxIdentifierLength = modelBuilder.Model.Relational().MaxIdentifierLength;

It can also be modified:

modelBuilder.Model.Relational().MaxIdentifierLength = newValue;

but I won't recommend that. Each db provider sets by default the maximum supported identifier length (for SqlServer it's 128), hence configuring greater value will probably lead to invalid table / constraint names and runtime exceptions.