Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints
Right click the table adapter and there is an option to delete the primary key(s). Then it worked.
Right click the table adapter and there is an option to delete the primary key(s). Then it worked.