Does anyone have any experience trying to store appointment reccurrence in a database?
Do you have to store the Reccurrence in a byte[ into the database?
My business object has a property for ReccurrenceID and Reccurrence but I am at a lose as to what type of property they should be and how i can store and retrieve reccurrence data from the DB
You help is much appreciated!!
Menita
You just store the Appointment object as a whole. Recurrence information is already embedded in it.
This solution is viable; I just want to add that the AppointmentRecurrence class exposes a 'Save' method which serializes the state of the object to a byte array using the Simple Object Access Protocol (SOAP). There is an accompanying static 'Load' method which returns an AppointmentRecurrence created from a byte array implied to have come from the Save method.
I am not a database maven but the WinSchedule Database Demo sample includes an MSAccess database and a SQL server create script...whatever field the 'AllPropertiesMember' is bound to should also work for storing a recurrence.
Thanks! I will try that.