If two tables have foreign keys with the same name an index is appended in
This results to an error in SqlCeDiff.CreateDiffScript(...):
List<Constraint> targetFKs = targetRepository.GetAllForeignKeys().Where(fk => fk.ConstraintTableName == tableName).ToList();
targetFKs has wrong foreign key names resulting in a script like
ALTER TABLE [MyTable] DROP CONSTRAINT [FK_bla_grmpf1];
ALTER TABLE [MyTable] DROP CONSTRAINT [FK_bla_grmpf];
This problem did not occur in a previous version e.g. 18.104.22.168 (Build 85301)
Temporarly it helped to restore the old algorithm using GetAllForeignKeys(string tableName):
List<Constraint> sourceFKs = sourceRepository.GetAllForeignKeys(tableName);
List<Constraint> targetFKs = targetRepository.GetAllForeignKeys(tableName);
Currently I don't see the necessity to fetch all foreign keys table name independant (and so possibly made
unique) as they are still filtered afterwards with Linq.
But never mind. No offense. The project is still great.