This fixes a major design flaw in the data model.
ItemSets now have a reference to a ItemOptionDefinition instead of a collection of options. This way, we have a clean way to define set options without many-to-many references to IncreasableItemOption. This also solves the multiple foreign keys in the IncreasableItemOption table and different options for the composition root.
Had to introduce some sql at the ef migrations to fix existing data.
This fixes a major design flaw in the data model. ItemSets now have a reference to a ItemOptionDefinition instead of a collection of options. This way, we have a clean way to define set options without many-to-many references to IncreasableItemOption. This also solves the multiple foreign keys in the IncreasableItemOption table and different options for the composition root.
Had to introduce some sql at the ef migrations to fix existing data.