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?
EF - Index & Foreign Keys Name Length
Re: EF - Index & Foreign Keys Name Length
Refer to https://www.devart.com/dotconnect/postg ... tions.html > the TruncateLongDefaultNames option.
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)