I have had a bug in my code which erroneously added settings to the SettingsRepository using the following code (simplified):
var propertySettingsRepository = ServiceLocator.Current.GetInstance();
var newSettings = new PropertyMediaSettings()
var settings = new PropertySettingsWrapper(Name, string.Empty, true, false, newSettings);
var settingsContainer = new PropertySettingsContainer(settingsId)
My problem is that i have lost all refernce to the settingscontainer, but this code ran enough times to build up a really big table of data.
How can I delete all this data? I cannot find any method to enumerate all existing settings using IPropertySettingsRepository
Have a look in tblSystemBigTable in the database and see if you can find them there.
You can try using the Geta's DDSAdmin addon.
Both PropertySettingsContainer and PropertySettingsWrapper are stored in tblSystemBigTable through PropertySettingsRepository which calls the underlying DDS store, this means you can use DynamicDataStore to enumerate all existing settings by yourself.
Thanks, I found hte settings in the DynamicDataStore (using the Geta tool).
However when I tried to delete the settings my database somehow got corrupt and the page properties using the deleted settings was no longer editable. (Object Reference Error).
I probably should make sure I did not use any of the settings before deleting them. Also I'm conserned that while I can delete the settings , the settingsWtrappers and SettingsContainers will still linger somewhere in the database.
Is it possible to get the wrapper or container from the settings (using the id)?