Modifying existing data in DynamicDataStore

Jan Montano

Vote:

public enum CompletionType { Certified, Passed, Pending, Suspended }

public class UserCourseRecord: IDynamicData

{

public CompletionType CompletionStatus {get; set;}

...

}

I have a UserCourseRecord class and data is saved using the DynamicDataStore.

It has a CompletionStatus property which is just an enum. That property is saved as just CompletionStatus.ToString().

Now I need to change CompletionType.Suspended to CompletionType.Incomplete and change all references of it on the database.

I'm currently tracking it on the database but I'm still figuring out what table/s are being used by the DDS. I'm looking at tblBigTable right now and planning to create a script to change occurrences of "Suspended" to "Incomplete"

Would this be the correct way of modifying the data or is there any other more efficient way of achieving this?

Thanks.

#50945

May 18, 2011 2:56

Anders Hattestad

Vote:

What about adding your new enum value. Then loop over all that uses the old value and change it and save Then removing the old enum value

#50947

May 18, 2011 7:59

Jan Montano

Vote:

Just got a deeper look on the tblBigTable. The good news is the ENum is not saved as string (as mentioned) but as index. So I just modified the enum name and everything's good.

#51038

May 23, 2011 7:28