HasCheckConstraint does not work with columns starting with uppercase

[rajmondburgaj]

I am trying to run a migration where I use HasCheckConstraint method on one entity. For some reason it complains like the column is not there, but the column is present in the entity. I think somehow the column name is changed to lowercase and maybe is not able to find it the table, therefore throwing.

modelBuilder.Entity<FeatureDbEntity>(entity =>
{
      ...
      entity.HasKey(x => x.Id);
      entity.HasCheckConstraint("CK_Features_Version", "Version > 0");
      ....
}

[roji]

You need to quote the column name Version in the check constraint SQL - PostgreSQL folds unquoted identifiers to lower-case, which is why it's complaining about lower-case version not being found:

entity.HasCheckConstraint("CK_Features_Version", @"""Version"" > 0");