EF - Index & Foreign Keys Name Length

[Tarek89]

Hi,
PostgreSQL have a limitation for Index and ForienKey names of 63, however, the default behavior is to just truncate the name. DotConnect PostgreSQL provider fails to update the database because of these errors. Is there anyway to ignore these errors or modify the ForeignKeys before creation?

[Shalex]

PostgreSQL have a limitation for Index and ForienKey names of 63, however, the default behavior is to just truncate the name.

Refer to https://www.devart.com/dotconnect/postg ... tions.html > the TruncateLongDefaultNames option.

DotConnect PostgreSQL provider fails to update the database because of these errors. Is there anyway to ignore these errors or modify the ForeignKeys before creation?

If config.CodeFirstOptions.TruncateLongDefaultNames=true; doesn't help, an alternative solution could be setting Index and ForienKey names explicitly via:
a) fluent mapping (EF 6.2 and EF Core)
b) code-based code-first migrations (EF 6.1 and earlier)