We need to display in a grid a recurrent appointment in separate records.
Considering that the recurrent appointment is stored as one record in the Schedule table, how we could achieve this.
Do you think we should create a record per day in the Schedule table when an recurrent appointment is created or would be better to parse the Recurrent string, for example: (FREQ=DAILY;INTERVAL=1;COUNT=19;EXDATE=5/3/2017,5/5/2017)
to project it in several records during runtime.
We expect to have thousands of schedule records with hundreds of concurrent session.
What option could you think would be the best for us, or if you have a clever idea.
We have prepared the sample to show the recurrence appointment with all its occurrence in Grid which can be download from the below location. Kindly refer the below link and code example used in the sample.